how do I return a value for the sheets number position? I can return the name:
Sheets.Name
But I want the value 34 if it were the 34th sheet out of 50 sheets. How do
I find this?
Please advise.
Thank you
how do I return a value for the sheets number position? I can return the name:
Sheets.Name
But I want the value 34 if it were the 34th sheet out of 50 sheets. How do
I find this?
Please advise.
Thank you
Sheets(sheet_name).Index
--
HTH
Bob Phillips
"Sheets number position" <Sheets number [email protected]>
wrote in message news:[email protected]...
> how do I return a value for the sheets number position? I can return the
name:
> Sheets.Name
>
> But I want the value 34 if it were the 34th sheet out of 50 sheets. How
do
> I find this?
>
> Please advise.
> Thank you
If you want to return the postion of the sheet then:
activesheet.index
or
sheets("MySheet").index
If you want to refer to a sheet by its postion then
sheets(34).select 'etc
hope this helps
Rowan
Sheets number position wrote:
> how do I return a value for the sheets number position? I can return the name:
> Sheets.Name
>
> But I want the value 34 if it were the 34th sheet out of 50 sheets. How do
> I find this?
>
> Please advise.
> Thank you
Hi,
The sheets index property returns its position in the sheets collection.
---
Regards,
Norman
"Sheets number position" <Sheets number [email protected]>
wrote in message news:[email protected]...
> how do I return a value for the sheets number position? I can return the
> name:
> Sheets.Name
>
> But I want the value 34 if it were the 34th sheet out of 50 sheets. How
> do
> I find this?
>
> Please advise.
> Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks