Create Macro replace blank cells with COUNTA

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 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
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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