| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
R/T error 40036
With data in Range a1:a9 of sheet1
Why in the Immediate window when I enter: lrow = activesheet.cells(Rows.Count, 1).end(xlUp).row or lrow = activesheet.cells(Rows.Count, 1).end(xlUp) Why do I get this error Application-defined or Object-defined error? TIA, Jim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R/T error 40036
I don't get the error unless the selected sheet is not a worksheet. For
instance, if you have a chart on the sheet and the chart is selected, you'll get an error on this code. James "JMay" wrote in message ... With data in Range a1:a9 of sheet1 Why in the Immediate window when I enter: lrow = activesheet.cells(Rows.Count, 1).end(xlUp).row or lrow = activesheet.cells(Rows.Count, 1).end(xlUp) Why do I get this error Application-defined or Object-defined error? TIA, Jim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R/T error 40036
I thing Excel sometimes get indigestion - I closed the wb in question started
a new one,,, it worked.. "Zone" wrote: I don't get the error unless the selected sheet is not a worksheet. For instance, if you have a chart on the sheet and the chart is selected, you'll get an error on this code. James "JMay" wrote in message ... With data in Range a1:a9 of sheet1 Why in the Immediate window when I enter: lrow = activesheet.cells(Rows.Count, 1).end(xlUp).row or lrow = activesheet.cells(Rows.Count, 1).end(xlUp) Why do I get this error Application-defined or Object-defined error? TIA, Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| Run-time Error 40036 on ActiveSheet | Excel Programming | |||
| Run time error 40036 | Excel Programming | |||
| Error 40036 when activating a sheet | Excel Programming | |||
| Run-time error 40036 | Excel Programming | |||
Linear Mode
