Hi all,

am looking for a script that will search a row for blank cells and if there are more than four consecutive (say 6) it will fill two of them with a given value or text.

The "gotcha" is that the row may two or three blocks with more than four blank cells in a row. In this case I want it to do the same as above i.e. insert a value or text.

After these two steps I want to add up the values or the text I've entered.

Is this possible?

Am relatively poor with VB...

Also just a note: I thought this was more of an excel question and have therefore started this in a different part of this site. However I think it is more relevant for this part of the forum, the old post is here: http://www.excelforum.com/excel-form...02#post3020402.

Thanks in advance for your help all.

Regards,

crazy