PDA

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.