R/T error 40036

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
I thing Excel sometimes get indigestion - I closed the wb in question started
a new one,,, it worked..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search other sheets for numbers & color them 10
Shed some light on this WS_Calculate macro. 3
Array code only works on selected sheet 14
Resize a row but copy but skip columns I don't want to copy 6
help please 4
Macro to Combine Data from Multiple Sheets with Cell References 4
Open four Wbooks, copy four columns from each to Master Wbook 16
Similar Book to Book Code, one works other does not 11

Back
Top