Thread: Help with code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg B[_12_] Greg B[_12_] is offline
external usenet poster
 
Posts: 10
Default Help with code

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