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
Bookmarks