Sheets(i).Select gives App-defined or Obj-defined error

Hi,

The Sheets(i).Select line gives a runtime error "application-defined or object-defined error".

Please Login or Register  to view this content.

The code was copied from another workbook's Module 1 and ran ok there.

This version runs further, until it reaches the Activesheet line, then gives the same error:

Please Login or Register  to view this content.

thanks,
John

i don't know, it worked for me, I put 2 charts on sheet1, none on sheet2, and none on sheet3

the second code box in your original post gave me 2,0,0 for the counts, so it did what it was supposed to, likewise Cnt gave me 1,-1,-1 again worked like it was supposed to


i'm guessing that the code in the first code box in your original post is part of a longer macro, did you dim sht as worksheet? also are you doing a similar task of selecting the sheets to count the chart items?

something else must be wrong

further details please

Scott,
Yes, I did Dim sht as Worksheet. I cut down the code to present only the relevant parts. In my full code, this particular sub is used to format row heights between the charts to 0.1 so they're effectively hidden. Other code sections actually manipulate individual chart options.

I think I'll start fresh with a blank worksheet, and try again. Something not obvious is at work here.

Thanks,
/John

If there is hidden sheet, you will get that error.

Hi, sorry for the weekend delay - I'm back on this issue now. Thanks for the replies!
So far:
- I have no hidden sheets
- I can open a fresh worksheet and run my macro successfully
- I cannot run it on the worksheet I'm actually using.
- There is no worksheet protection set
- I can use a watch variable of Sheets(i) successfully; I just can't perform the Sheets(i).Select.

Please Login or Register  to view this content.