Thread: Hide Cols ??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LiAD LiAD is offline
external usenet poster
 
Posts: 386
Default Hide Cols ??


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