Hi
why do you want to select it?. Normally no reason for this

--
Regards
Frank Kabel
Frankfurt, Germany

"Sohpie" schrieb im Newsbeitrag
...
Hello Everyone!

I've had a good search for this but had no luck
I want to select a workbook using the
Worksheets(5).Select type syntax

But I to be able to set the first number according to the
sheet that is currently active using Worksheets
(mysheet).Select
Where mysheet is an integer

I think the code will look something like this
mysheet = activesheet.position (but don't know the
correct property for .position)

Can anyone help?

TIA

Sxx