Help fix my loop to fill in blank cells down a row

[mellowmarshall]

Used some code I'd gotten help with in the past, its not working quite right though. Two problems with it:
1. gets stuck in the inner Do loop forever
2. fills in one blank cell, loops until nonblank cell, returns to last blank cell and starts over

Please Login or Register  to view this content.

excelforum vb example.xlsm

[mellowmarshall]

Ugh nevermind.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

You don't necessarily need a macro. Normal XL functions will work perfectly well. See attached.