Thread: Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_23_] Michael[_23_] is offline
external usenet poster
 
Posts: 4
Default Macro

Hi All
I have a large financial spreadsheet that is sent to me
from another source. I have written a macro to remove all
unwanted data and make a summarized printout. However,
each month the spreadsheet gets one column wider due to
the extra month. How can I rewrite my macro so that it
hides this extra month when it runs. eg, My macro hides
columns C to G, next month it will have to hide C to H,
etc, etc.
Hope you can help
Regards
Michael