select all worksheets in a workbook
 

Is there a quick code to select all worksheets in a workbook....no sheet
is hidden....i want to use cell.select - but do it for everysheet and
not just one sheet...

thank you for any help


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=570080

select all worksheets in a workbook
 

Untested but you can try this...

sub SelectAllSheets
dim wks as worksheet

for each wks in worksheets
wks.select false 'Select all sheet
wks.cells.select 'Select all Cells
next wks
end sub
--
HTH...

Jim Thomlinson


"jhahes" wrote:


Is there a quick code to select all worksheets in a workbook....no sheet
is hidden....i want to use cell.select - but do it for everysheet and
not just one sheet...

thank you for any help


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=570080

select all worksheets in a workbook
 

One mo
Worksheets.Select

or if you want to include chart sheets:
sheets.select

jhahes wrote:

Is there a quick code to select all worksheets in a workbook....no sheet
is hidden....i want to use cell.select - but do it for everysheet and
not just one sheet...

thank you for any help

--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=570080

--

Dave Peterson