Hello,

I have four worksheets that have labels in exactly the same cells as each
other.

What I want to do is create named ranges in one worksheet, and then copy
them over to the other worksheets so that I only have to change the name of
the sheet that the range is referring to (as the cells are the same).

I know how to make named ranges in one worksheet....I'm looking for a quick
way to copy those named ranges to the other worksheets.

I hope this makes sense - thanks.