What Is WorkSheet ?REG??

[Cyberdude]

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]

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]

Possibly "Shares" is the name of a module or form?

That got me once or twice

Paul