Macro to replace emplty cells with "(blank)" text

[kapil]

Hi,

Can some one help me with the below code. I want to replace Empty cells in my column with text = "(blank)"

This is what I have written. But it is not working.

I will highly appreciate your help in this regard.

Please Login or Register  to view this content.

[kapil]

I got answer for this... Have modified my previous code and its working fine.

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

[DonkeyOte]

edit: code below is just a repetition of shg's - board very slow (again) this morning....

You need to be careful regards your construct should Main not be active sheet at run time - you also need to account for possibility of no blanks in the range

Please Login or Register  to view this content.

On a final note - if you've posted the question elsewhere detail as such on this forum - failing to do so will lead to your posting rights being suspended.