VBA - identifying which worksheet is active
 

Must be the weather or something but ...
I am having problems working out how to retrieve the sequential number of an
active worksheet (Activeworksheet does not supptort the various properties I
have tried...). Yeah, I know, should be trivial but I am obviosuly not
thinking of the right key words to find any help either. Suggestions much
appreciated. All I want to do really is count how many more worksheets I have
after the active one.
Many thanks and best wishes.

VBA - identifying which worksheet is active
 

The property you are looking for is Index...

NumberOfSheetsRemaining = Worksheets.Count - ActiveSheet.Index

Rick


"Boris" wrote in message
...
Must be the weather or something but ...
I am having problems working out how to retrieve the sequential number of
an
active worksheet (Activeworksheet does not supptort the various properties
I
have tried...). Yeah, I know, should be trivial but I am obviosuly not
thinking of the right key words to find any help either. Suggestions much
appreciated. All I want to do really is count how many more worksheets I
have
after the active one.
Many thanks and best wishes.

VBA - identifying which worksheet is active
 

Thanks Rick, very good of you to reply. I had thought of "index" but, when I
tried it in my immediate window, I got a VB error message to say that the
property was not suppoted... Must have mistyped something!
Many thanks again, Boris.

"Rick Rothstein (MVP - VB)" wrote:

The property you are looking for is Index...

NumberOfSheetsRemaining = Worksheets.Count - ActiveSheet.Index

Rick


"Boris" wrote in message
...
Must be the weather or something but ...
I am having problems working out how to retrieve the sequential number of
an
active worksheet (Activeworksheet does not supptort the various properties
I
have tried...). Yeah, I know, should be trivial but I am obviosuly not
thinking of the right key words to find any help either. Suggestions much
appreciated. All I want to do really is count how many more worksheets I
have
after the active one.
Many thanks and best wishes.