This doesn't seem to work for me. Only a couple of named ranges get copied even though they are all set to worksheet scope. Is this even possible?