thanks Andy
in fact i did not even hear about R1C1 references before.
i got it now :)



"Andy Pope" wrote in message
...
It's a cell reference using the Rows and Columns R1C1 method.

R2C1 = A2
R3C1 = A3

Cheers
Andy

news.microsoft.com wrote:
i am looking at some vb code written for generating excel charts.

Sheet1!R2C1:R3C1

above value assigned to XValues of a series. Can someone explain it?
especially, i did not understand what "R" stand for?

thanks





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info