XValues = range from 2 different rows. Can I do it?

[Paddybongo]

Hello,
This is my first post. I'm definitely in the right place looking at the great answers I have seen so far....I'm a beginner :-)

I have multiple charts and am a bit stuck on the XValues for one of my charts. The Xvalues are split over 2 rows (XRow is not always the same Row number).

Can I do something similar to below to add the XValues to my chart?

.XValues = WS.Range(WS.Cells(XRow, 4), WS.Cells(XRow, 4) + (WS.Cells(XRow+5, 4), WS.Cells(XRow+5, 4)
Any help is much appreciated.
Paddybongo

[Paddybongo]

Hello,

Has anyone managed to do this before?

.XValues = WS.Range(WS.Cells(XRow, 4), WS.Cells(XRow, 15) + (WS.Cells(XRow+5, 4), WS.Cells(XRow+5, 15)

Your help is really appreciated,
Paddybongo

[Andy Pope]

Please Login or Register  to view this content.

[Paddybongo]

Andy,
Brilliant! Thanks a lot for taking the time to get back to me.
Paddybongo