View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Hiding Columns with Merged Cells


Unmerge the cells and then hide the column.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Steve Pollack"
wrote in message
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.