Hi Frank

There's a long process I need to go through
Very difficult to explain
Rather than just boring everyone I thought I'd ask the
simple question

What's the property for
mysheet = activesheet.position in workbook
If someone can give it to me then great
Or if someone can tell me it's impossible fine too
I'll just find a work around

Sophie



-----Original Message-----
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







.