VBA newbie here (but learning quickly)
I am trying to zoom to a set of columns. (say G:M)
I am aware of:
[vba]
Columns ("G:M").Select
ActiveWindow.Zoom = True
[/vba]
But I am trying to do it without actually using the 'select' command. Let me explain:
I have a worksheet that has the Worksheet_SelectionChange function and I am trying to have most of my code execute without having to disable Application.EnableEvents every time I want to do something. I am able to change cell vaues and properties without actually 'selecting' the cells i.e. :
[vba]
Range ("H9").Value = "hello"
[/vba]
or
[vba]
Range("H9").Interior.ColorIndex = 8
[/vba]
If I use the Select command then one of my functions forces the acive cell to column "A" and overrides the zoom area that I want. If Anyone can tell me how to zoom to a set of columns without having to disable events first it would be greatly appreciated.
Regards,
Jim