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