My Macro:
Works fine for the activesheet, how do i change the code above so it will work through ALL worksheets with some exceptions (Being Start, Template, Brokers and Graphs)?Please Login or Register to view this content.
My Macro:
Works fine for the activesheet, how do i change the code above so it will work through ALL worksheets with some exceptions (Being Start, Template, Brokers and Graphs)?Please Login or Register to view this content.
Hi, nickmax1,
maybe proceed like this:
Ciao,Please Login or Register to view this content.
Holger
Last edited by HaHoBe; 08-29-2012 at 07:15 AM. Reason: line number for start of range corrected
Try this
Please Login or Register to view this content.
Last edited by arlu1201; 08-29-2012 at 07:30 AM.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
spot on thanks!!
Arlette i get a next without For error with your code?
Last edited by nickmax1; 08-29-2012 at 07:18 AM.
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.
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Thanks Patel. I didnt realise i missed it. I edited my code as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks