PDA

View Full Version : What Is WorkSheet ?REG??



Cyberdude
11-12-2008, 05:18 PM
In one of my macros I got an ?invalid subscript? error when executing the statement:

Worksheets(?Shares?).Select

I executed the statement:

MsgBox "Active Sheet name is '" & ActiveSheet.Name & "'."

and the response was ?REG?.

Since I?m not consciously using a sheet named REG, I?m wondering, is that is some sort of system name?? (Weird, very weird)

GTO
11-12-2008, 06:34 PM
I certainly cannot imagine what happened there. I'm assuming you made several attempts and are getting the same error(s), can you post the workbook (sanitized of course)?

Mark

Paul_Hossler
11-13-2008, 01:09 PM
Possibly "Shares" is the name of a module or form?

That got me once or twice

Paul