I have about 30 worksheets, and I need to put my name on the top left corner (cell A1). Is there an easy way to do this without having to write it or paste it into every worksheet?
Select all the worksheets (select the first sheet, hold shift, select the last sheet)
Type your name in A1
This will do it for the non-code people.
This should do it:
The code should be put in a standard code module. (Alt+F11, Insert>Module, paste this in, change name in quotes, Run/F5 to execute)