Deleting range not a row
Range("A12:G12").Delete Shift:=xlShiftup
--
Regards,
Tom Ogilvy
Robert wrote in message ...
I have a workbook with data in columns A:N and I need to be able to
delete any blank part rows in columns A:G without disturbing the data in
columns H:N.
How do I delete ranges, eg A12:G12 where A12 is blank, without deleting
the remaining part of the row - H12 onwards?
I know how to delete individual blank cells or entire rows where a cell
is blank but not part rows.
Grateful for any suggestions.
--
Robert
|