Range(0, 0).Select

It is bad code. The syntax

Range(x,y)

will fail if x and y are any numbers.




--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Bill Martin" wrote in message
...
I have a macro I inherited with the code fragment below. I find
that if I
comment out the "on error" statement, the program fails at the
line
"Range(0,0).Select" with the Run-time error '1004': Method
'Range' of object
'_Global' failed.

Excel seems to think the Range line causes a error, yet if I
comment out the
Range line, the program fails to work so it is apparently doing
*something*.
The error handler simply says Resume Next so it's not doing
anything obvious (to
me anyhow).

On Error GoTo ErrorHandler
... (many lines of code) ...
Set DataSheet = ActiveSheet
DataSheet.Unprotect
Range(0, 0).Select

Can someone explain to me the logic of this fragment? I've
been unsuccessful
with the Excel Help system and with my normal reference books.
I would have
thought it was just the equivalent of Range("A1").select, but
apparently not.

Thanks...

Bill