Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Blank Rows - specify column via dialog
From time to time I have worksheets of data that have rows I want to
eliminate. The rows I want to delete usually have something in common like, all have a blank value in a specific column. In the past I have just modified a macro to specify which column I want to deal with. Like this for column B: Columns(2).SpecialCells(xlCellTypeBlanks).EntireRo w.Delete Wondering if there is a way to write a macro that when run would give me a dialog box and ask which column to look in so I don't have to change the macro for the different situations. Logically, something like this: Columns(DIALOG BOX ENTRY).SpecialCells(xlCellTypeBlanks).EntireRow.De lete Can you help? Thanks in advance, Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Blank Rows - specify column via dialog
Why not use the column of the active cell ?
Columns(ActiveCell.Column) See also this page for a possible problem http://www.rondebruin.nl/specialcells.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "porter444" wrote in message ... From time to time I have worksheets of data that have rows I want to eliminate. The rows I want to delete usually have something in common like, all have a blank value in a specific column. In the past I have just modified a macro to specify which column I want to deal with. Like this for column B: Columns(2).SpecialCells(xlCellTypeBlanks).EntireRo w.Delete Wondering if there is a way to write a macro that when run would give me a dialog box and ask which column to look in so I don't have to change the macro for the different situations. Logically, something like this: Columns(DIALOG BOX ENTRY).SpecialCells(xlCellTypeBlanks).EntireRow.De lete Can you help? Thanks in advance, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to delete rows if cell blank in column | Excel Discussion (Misc queries) | |||
Delete Rows if any cell in Column H is blank but do not Delete Fir | Excel Programming | |||
Delete entire rows where there is a blank in column A | Excel Programming | |||
To Delete the specific rows when blank is found on column A | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming |