Muliple names in a range?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cliff - 03 Apr 2004 01:25 GMT

Is it possible to have multiple named references within a range ID, for example:

Worksheets("Sheet1").Range("Year_1", "Year_3").Value = 0

where both Year_1 and Year_3 are named ranges themselves?

Cliff

Reply to this Message

Dave Peterson - 03 Apr 2004 01:34 GMT

You can use a union of the two ranges:

Option Explicit
Sub testme()
With Worksheets("sheet1")
Union(.Range("year_1"), .Range("year_3")).Value = 0
End With
End Sub

But this just seems more straightforward to me:

Option Explicit
Sub testme()
With Worksheets("sheet1")
.Range("year_1").Value = 0
.Range("year_3").Value = 0
End With
End Sub

> Is it possible to have multiple named references within a range ID, for example:
>
[quoted text clipped - 3 lines]
>
> Cliff

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

Cliff - 03 Apr 2004 01:43 GMT

> You can use a union of the two ranges:
>
[quoted text clipped - 22 lines]
>>
>>Cliff

Thanks, Dave...that works for me.

Reply to this Message