Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
i need a quick answer.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
i need a quick answer.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Need A Quick Answer Please! | Excel Discussion (Misc queries) | |||
Euler's Number *Should be quick answer | Excel Discussion (Misc queries) | |||
Quick answer please! | Excel Worksheet Functions | |||
two quick questions on excel. please answer as soon as possible... | Excel Worksheet Functions | |||
Need a Quick answer on this one......... | Excel Programming |