View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Martin[_2_] Bill Martin[_2_] is offline
external usenet poster
 
Posts: 105
Default Range(0,0).Select ?

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