| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting range not a row
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting part of X-axis range | Charts and Charting in Excel | |||
| Deleting or changing a range name | Excel Discussion (Misc queries) | |||
| deleting worksheets from names in a range | Excel Discussion (Misc queries) | |||
| Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
| Deleting/Replacing Values in a Range | Excel Programming | |||
![Robert[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
