Creating sheet specific names ranges
 

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

Thanks

Creating sheet specific names ranges
 

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



Barb Reinhardt wrote:

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

Thanks

--

Dave Peterson