Here are a couple mo


with activesheet
.range(.columns(7),.columns(10)).hidden = true
end with

or

activesheet.columns(7).resize(,10-7+1).hidden = true


Gary Keramidas wrote:

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

--

Dave Peterson