View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default i need a quick answer.

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