Selecting Workbooks

[Sohpie]

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

 

[Frank Kabel]

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

 

[Jim May]

CurrSht As Integer
CurrSht = ActiveSheet.Index

 

[Jarek]

Hi,
I'm not sure about your question, but maybe you're lookin fo
ActiveSheet.Index ?

Jare

 

[Guest]

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

 

[Sophie]

Hi Jarek

That's exactly what I'm looking for!

thanks Jarek

Sx

 

[Sophie]

That's Great

Thanks Jim

Sx

-----Original Message-----
CurrSht As Integer
CurrSht = ActiveSheet.Index





.