I am getting an "Object doesn't support this property or method" error at ".SeriesCollection.XValues = Sheets("Plot").Range(Cells(3, 1), Cells(3, 1).xlDown)". Could somebody please offer an explanation and solution?
Thanks!
Please Login or Register to view this content.
One problem that I see is the missing .End. look at this:
Please Login or Register to view this content.
If you are pleased with a member's answer then use the Star icon to rate it.
will this work
replace the .SeriesCollection.XXXX with this....without seeing your data I'm just shooting in the dark....on fully automatic....Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Buran, I certainly was missing the .End. Thanks. The .SetSourceData method works nicely. Here if my final code:
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