Morning All 
I’ve used range names for a while now and sometimes noticed that some range names are related to specific sheets. In particular, the Print_Area is shown with a sheet name.
What I want to do is assign a particular cell a certain range name that is only valid for that sheet. If I change sheets, then the range name points to a different cell. Then, in a macro, I can use that range name and know that I am getting the value from the cell for that sheet.
The question is, how do I create one of these range names that are sheet dependent?
Cheers,
Tim
