VBA newbie here (but learning quickly)

I am trying to zoom to a set of columns. (say G:M)

I am aware of:

Columns ("G:M").Select
ActiveWindow.Zoom = True

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. :

Range ("H9").Value = "hello"

or

Range("H9").Interior.ColorIndex = 8

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


--
Staging2000
------------------------------------------------------------------------
Staging2000's Profile: http://www.excelforum.com/member.php...o&userid=31714
View this thread: http://www.excelforum.com/showthread...hreadid=514168