Create Macro replace blank cells with COUNTA [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,

I want to create a macro that will find a blank cell with Counta value of > 0 and delete that entire rows.

1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi Phil,

A cell with a Counta formula isn't blank. Sorry, had to point that out.

In which range can the Counta formula be found?
Is it a single column?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!