Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to delete columns
Hello,
I have a macro to import text file data into an Excel spreadsheet. Sometimes, several columns imported have blank data and can be random columns. I would like to write a macro to do the followings: 1) From column A-M, If any column along row cell 9 is blank, then delete the entire columns with blank data. Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I update macro to delete zero amount columns? | Excel Discussion (Misc queries) | |||
Auto Delete Columns in a Macro that are Blank | Excel Discussion (Misc queries) | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) |