Thread: Hide Cols ??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default Hide Cols ??


looks ok to me

Columns("G:L").EntireColumn.Hidden = True

in Excel 2003 and 2007 ONLY these columns get hidden.



"LiAD" wrote in message
...
Hi,

Using the recorder I got the following macro to try to hide cols G to L.

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

When I run the macro it hides from col B to col M inclusive. I have tried
unmerging any cells in these cols that overlap with the range I want to
hide
etc but it makes no difference.

How do I get a code to hide the cols i wish?
Thanks