| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help PLEASE
With Columns("I:I")
On Error Resume Next ..Replace What:=0, Replacement:="#n/a", LookAt:=xlWhole ..SpecialCells(xlCellTypeConstants, xlErrors).EntireRow.Delete End With This works for me but THE WOMAN AT THE OFFICE WOULD LIKE NOT TO DELETE COLUMNS WITH ZERO VALUES. BUT TO CUT AND PASTE THEM AT THE BOTTOM OF THE SHEET This only part of the whole Macro but this is the part that Deletes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error when running cut & paste macro | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
Threaded Mode
