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

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

CurrSht As Integer
CurrSht = ActiveSheet.Index


"Sohpie" wrote in message
...
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

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

Jare

--
Jare
-----------------------------------------------------------------------
Jarek's Profile: http://www.excelforum.com/member.php...info&userid=96
View this thread: http://www.excelforum.com/showthread.php?threadid=26721

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







.

Hi Jarek

That's exactly what I'm looking for!

thanks Jarek

Sx

-----Original Message-----

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

Jarek


--
Jarek
---------------------------------------------------------
---------------
Jarek's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=965
View this thread:
http://www.excelforum.com/showthread...hreadid=267212

.

That's Great

Thanks Jim

Sx


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


"Sohpie" wrote in
message
...
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








.