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
|