Hi,
I'm trying to copy a named range without having to have the name of the range hard coded but having difficulty getting this to work, attempt below but it's not working as I expected it to:
This is at the top of the Module as I'm using a UserForm to define the variable site_name:
Public...