Help with code

[Greg B]

I have a piece of code I cant work out why it is not allowing me to
continue, here is the line

Sheets(REGNUM).Activate

what happens is the program ask for the membership number and then activates
that page but for some reason it is coming up with
runtime error 9
subscript out of range

What does this mean?

Thanks in advance

Greg B

 

[Greg B]

It is ok I forgot to put the .caption after the regnum part

Thanks
Greg B

 

[FSt1]

hi
"Script out of range"
you usually get this error when excel is told to select or goto something
that does not exist.
based on your 2 posts, i assume this is the line.....
Sheets(REGNUM).caption.Activate
loose the .caption part.
you can activate a sheet but i know of no way to activate a caption.
captions are like the names at the top of a form or on a button face and are
string data types. you can select an object(sheet) but you can't select a
string.(you can display a string in a msgbox and other ways)

regards
FSt1