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

These 2 statements can work:

Range(Cells(1), Cells(1)).Select

Cells(1, 1).Select

But I don't think Range(0, 0).Select can ever work.

Maybe show all the code.


RBS




"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

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 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

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 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

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