Hi guys, this macro works but is there anyway I can change theso that ("Sheet1") can be any number? possibly using the ("*") which i think relates to any number. Every time a sheet is added it goes 2,3,4 etc. At the moment this is set up to change sheet1, any help would be greatly appreciated.Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks