Graph/Range help needed...

[Red]

Ok, yada yada yada, I know this is the Access group, however, I need
help in Excel :D


Here's the thing,

I'm exporting data to excel (From Access), adding code from a string,
and executing the code... no biggie, I do it daily.. my superiors are
high on Excel....

Anyhow, I need to convert this into something I can throw variables
into:
Range("C1:E1,C4 :E4")

I'm trying to loop through each line (in the spreadsheet) to make a
seperate graph for ech line
The first 'range' is the series data names (C1-E1).. the second 'range'
is the actual data...

I need to be able to turn it into something like:
Range((Cells(1, 3), Cells(1,5)),(Ce lls(X,3), Cells(X,5)))
However, if you know anything about ranges, that doesn't work.. and I'm
fairly stumped, and I really hate sifting through manuals and reference
books =P

Any help would be appreciated =)

~Red

[Red]

Re: Graph/Range help needed...

Someone emailed me, I will not share his name, because I figured he'd
share it here if he wanted to share his name, but this is what I eneded
up using:

Union(Range(Cel ls(1,3),Cells(1 ,5)), Range(Cells(4,3 ),Cells(4,5)))


Thanks to the guy that helped :D

~Red