Adding text to missing cells

[evbrock]

I am using this code in my macro that fills in any blank cells in column A (First Name) with the word "Friend", if the first name is missing.

Please Login or Register  to view this content.

However, if there are no blank cells, I get an error message about it and it stops running. How can I fix this, so that if there are no blank cells, it just keeps going?

(Forgive me, I realize this is really simple and should be obvious... but I'm new to VBA and can't find the answer!)

[KOKOSEK]

Hi

Maybe this way:

Please Login or Register  to view this content.

[PCI]

Do not use

Please Login or Register  to view this content.

else you are covering the full column ...

See next code

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.