| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete and Move Up
Hi...
I have 3000 records. In column B, some cells are reading #N/A. I need some code that will delete the rows where the #N/A occours and leave no gaps. So by the time I'm through I have say 2800 records with no gaps in the rows? Is this possible? Thanks Gordon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting every other row to delete or move | Excel Discussion (Misc queries) | |||
| How do I set up an automatic delete or move of a row of data? | Excel Discussion (Misc queries) | |||
| Button to move row and delete old row | Excel Programming | |||
| Move text after delete | Excel Programming | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
