Create Macro replace blank cells with COUNTA

Closed
Phil - May 3, 2011 at 09:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 3, 2011 at 10:36 AM
Hello,

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

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 3, 2011 at 10:36 AM
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
0