Is it possible to create a range that is recognized on one worksheet only? This would enable to use the same range on another sheet, is that correct?
Is it possible to create a range that is recognized on one worksheet only? This would enable to use the same range on another sheet, is that correct?
HI, Welcome to VBAX!
Yes it is possible, although you might want to be more clear on what you may need.
You can define a name for a range using:
Insert>Name>Define
which would enable the use of the name in place of the actual cells addresses...
Care to elaborate?
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
What you do is, within the name define (Insert>Name>Define...), and in the Names textbox insert the range name preceded by thae name of the sheet you are on, such asOriginally Posted by phiore
Sheet1!myRange
Add the range address in the RefersTo box as normal.
This creates a worksheet name which applies to that sheet, and the same name can be applied on another sheet, applying solely to that sheet.
thanks, exactly what i was looking for. really appreciate it.