Code won't work when sheetname is changed

Originally Posted by Richard Buttrey

Hi,

See attached.

Your SF1 sheet has the VBA code name Sheet3 so it's hardly surprising that using Sheet1 didn't work.
I also noticed that there were getting on for 200 range names of which 100 were errors. The fact that there were range names on SF1 that's being copied means that an extra instruction Application.DisplayAlerts = False is necessary to prevent pop up warnings.

The revised file is attached.

Thanks a lot!!!!

Though I really didn't understand a thing about what just happened.