View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Pollack Steve Pollack is offline
external usenet poster
 
Posts: 2
Default Hiding Columns with Merged Cells

I would like to include instructions in a macro to hide a column.
Part of the column contains merged cells.
When I record a macro for the process I want, the instructions read:

Columns("D:D").Select
Selection.EntireColumn.Hidden = True

However, when these instructions are incorporated into my macro both columns
D and E (due to the merged cells) are hidden.

Any help would be appreciated.
Thanks.