Hello!
I have some code below that used to work and now all of a sudden it doesn't.
The code is failing at ActiveSheet.Shapes.AddChart.Select
I have never had an issue with the code not running through the entire procedure. Is there a work around for where the code is failing?
Thank you!
Please Login or Register to view this content.
I don't know why it fails but selecting is not required
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Hey JP,
I tried your code, and it still fails at the first line ActiveSheet.Shapes.AddChart.Chart
Any more thoughts?
did you protect the sheet? or share the workbook?
Hey JP,
Sheet is not protected nor has the workbook been shared.
do you have more than one sheet selected?
No, only one sheet is activated...
can you post a workbook?
Including this clause works:
Please Login or Register to view this content.
that's not the same thing-it gets a reference to an existing chart rather than creating a new one. also theis totally unnecessary (you ought never to need that!)Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks