Skip to Content
0
Former Member
Aug 13, 2009 at 04:41 AM

How to delete rows in Excel using VBA Macro with Cell Range?

104 Views

Hello All,

I want to delete all rows from a Cell Range in an workbook (e.g. H22 to P222) where the Cell is empty.

I have values in G Column which are basically Cost Element Description.

The code supposed to check the range From H22 to P222 and if it finds a complete row (e.g. H22 to P22) is blank, it should delete teh complete row.

Please help.

Regards,

Mainak