View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luong Luong is offline
external usenet poster
 
Posts: 4
Default 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.