Creating sheet specific names ranges

B

Barb Reinhardt

I know how to create sheet specific range names using VBA, but want to know
if it can be done without VBA.

Thanks
 
D

Dave Peterson

Insert|Name|Define
Names in workbook box: 'Your Sheet Name Here'!NameGoesHere
refers to: ='Your Sheet Name Here'!$D$16
 
Top