Referring to multiple ranges

[stendahl_jones]

I want to refer to multiple ranges, but I do not want to refer directly to
the cell address since these change all the time. Instead I want to refer to
the cells by using an expression like variable.Address or something like
that. Normally when refering to multiple ranges you simply write like this:
Range("C59,G9:H16,B1418"). However when I try to write like that but
using the indirect reference my program does not understand.
My code is:
ActiveChart.SetSourceData
Source:=Sheets("Indata").Range("rng1.Address:rng1.Offset(1, 0).Address,
rng2.Address:rng2.Offset(3,0).Address")

Please help me on this one!! I have tried everything but I still dont get it
!! Please, please help me!!

 

[crazybass2]

Stendahl,

You have the right idea, but needed some tweeking. Since rng1 and rng2 are
variable ranges in VBA and not a range name in Excel, you need to have them
outside the "". Try the following:

=Sheets("Indata").Range(rng1.Address & ":" & rng1.Offset(1, 0).Address & ","
& rng2.Address & ":" & rng2.Offset(3, 0).Address)


Mike