what does this symbol stand for

[drag-driver]

In the below equation in Vb what does THe R in the referance refer to .:
ActiveChart.SeriesCollection(2).XValues = "='DSQ401 -- Data'!R1C4:R1C26"

thanks,
Thomas

[Mark W.]

row

[Ivan F Moala]

On 2002-05-21 06:49, drag-driver wrote:
In the below equation in Vb what does THe R in the referance refer to .:
ActiveChart.SeriesCollection(2).XValues = "='DSQ401 -- Data'!R1C4:R1C26"

thanks,
Thomas

The R refers to Row.
You are using XlReferenceStyle xlR1C1.
Use xlA1 to return an A1-style reference. Use xlR1C1 to return an R1C1-style reference. The default value is xlA1

So in the above R1C4:R1C26 is;
A1 Style "D1:Z1"

Look up online help for more info.

[Ian Mac]

Hi,

There no need to start another thread, this is directly related to your earlier questions.

I've left the other thread open for the REAL VBer's to jump in.