Re: Range(0,0).Select ?

Thanks to both of you who responded. I'm quite willing to accept that the line
is incorrect -- I just didn't have the confidence to declare it as such myself!

Thanks...

Bill
--------------------------
Charlie wrote:
> Range(0, 0).Select is incorrect for two reasons:
>
> 1) Excel sheets are "one-based", i.e. cell "A1" is equivalent to Cells(1, 1)
>
> 2) The Range statement cannot reference cells by row and column number, use
> the Cells statement instead:
>
> Cells(1, 1)
> not
> Range(1, 1)
>
> The On Error Resum Next statment simply ignores the erroneous line and
> continues to the next line of code. I think the intention here was to reset
> the cursor to cell A1. Change the erroneous line to:
>
> Range("A1").Select
>
>
> "Bill Martin" wrote:
>
>
>>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 Data*** = Active***
>> Data***.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
>>
.