Or
Activesheet.Select

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
Just select any sheet.

Worksheets(1).Select

--
Regards,
Tom Ogilvy


"Claude" wrote in message
...
Hi all
What is the correct syntax to ungroup sheets in a workbook? I want to
make
sure that no sheets have been grouped by a previous user of the files
I'm
opening (as this causes problems with certain VBA procedures I'm running
on
the files). Can't find anything on this in the VBA help file...
Thxs!