Hello, i am producing hundreds of spreadsheets and need to name the tabs in accordance with a certain cell on each. I am using a custom macro button to do this on each active sheet by copying and pasting into the name. Or trying to! I can't make the following macro work, can you help, or is there another way which is better?
Range("a7").Select
Selection.Copy
ActiveSheet.Name = Range("A7").Paste
Range("a7").Select
Selection.Copy
ActiveSheet.Name = Range("A7").Paste