Macro to Clear CF in Col G where cells are Blank

**Howardc1001** · 05-30-2025, 12:50 PM

I have tried to write code to clear CF in Col G where cells are blank , but code does not clear this

Kindly test & annd code

Please Login or Register  to view this content.

**JohnTopley** · 05-30-2025, 02:50 PM

CF as

Formula:

Please Login or Register  to view this content.

Your macro sets LASTROW (=6) but your CF is all of column G and does allow for blank cells (treated as zero)

**Howardc1001** · 05-30-2025, 10:07 PM

Thanks for the help John. Using formula much better

Re: Macro to Clear CF in Col G where cells are Blank