Gary,

Just select one cell from each of the columns then use the
EntireColumn.Hidden method of the selection.

Range(Cells(1, 7), Cells(1, 10)).Select
Selection.EntireColumn.Hidden = True

You can substitute your own variables for the "7" and "10" above if you want
to hide some other columns instead.

Regards,
Mark


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
ok, thanks guys, one other question.

how do i hide a range of columns using column numbers?

something like:
columns(7,10).hidden = true


--


Gary


"Dave Peterson" wrote in message
...
In the activewindow???

msgbox activewindow.selectedsheets.count



Gary Keramidas wrote:

how do i determine if more than 1 worksheets is selected?

--

Gary

--

Dave Peterson