Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
Select Sheet then Select Range | Excel Programming | |||
Range Select | Excel Programming |