View Full Version : Solved: Creating Ranges
phiore
02-09-2006, 07:48 PM
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?
XLGibbs
02-09-2006, 08:00 PM
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?
Bob Phillips
02-10-2006, 01:17 AM
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?
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 as
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.
phiore
02-10-2006, 03:57 AM
:beerchug:
thanks, exactly what i was looking for. really appreciate it.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.