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

--


Gary

In the activewindow???

msgbox activewindow.selectedsheets.count



Gary Keramidas wrote:

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

--

Gary

--

Dave Peterson

Gary,

MsgBox ThisWorkbook.Windows(1).SelectedSheets.Count

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
how do i determine if more than 1 worksheets is selected?

--


Gary

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

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

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

thanks a lot to both of you

--


Gary


"Dave Peterson" wrote in message
...
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