Evening all,
I'm trying to adapt this piece of codeto run through all graphs in my workbook (about 60 in all) and update the line thickness and remove glow. There are graphs on Sheets 1 & 2 that I dont want this to happen on.HTML Code:
The way I've currently got it written it gives me a Compile Error: Next without For
As far as I understand there are 3 "Fors" above with 3 "Nexts" below.
Any help greatly appreciated.
Please Login or Register to view this content.
You are missing one End With statement:
Please Login or Register to view this content.
Aim high or don't even try.
---------------------------------
If your question has been answered, don't forget to mark the thread as SOLVED.
If you find an answer helpful, click on the star icon at the bottom of the post.
Hello Hydraulics
Thanks for your answer, thats certainly got rid of the Compile error. Now for some reason it doesn't think that theelement has been specified, despite sht being defined at the top.Please Login or Register to view this content.
Weird, because a similar script is working fine in another module. Any ideas?
Without seeing your workbook it's somewhat hard to tell what you should change, but this statement
should follow, and not precede, this linePlease Login or Register to view this content.
As it is now, it will complain that you are trying to access the name of the sheet (sht.Name) when you have only declared it at the top.Please Login or Register to view this content.
Try with
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