I was able to find some GREAT code to automatically resize the min and max Y-Axis for every graph on a workbook. Its great!
My problem is that I dont WANT to change them all. HA.... just Chart 14,Chart 15,and Chart 16
I have attempted to alter the code below to do my bidding but alas- I'm not a coder. If anyone could have a try I would be very appreciative.
-Ken
Please Login or Register to view this content.
added a Select Case statement into codePlease Login or Register to view this content.
just add/remove chart names you want to include/exclude in line below
names added will make it run the code for itPlease Login or Register to view this content.
names not on here will just get skipped
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
May I just say WOW humdingaling!!!! It works great. This little diddy will same me SSSOOOO much time. I hope that others will see this code and use it for their own applications.
Thanks again so much!!!
not a problem
glad to help
Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks