Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I am trying to drive excel from VC++.net and would like to insert data into a range addressed using the R1C1 style. Here is how I know it works (from the SDK samples): Range* range2 = worksheet-get_Range(S"A1", S"E1"); int array2 __gc[] = new int __gc[5]; for (int i=0; i < array2-GetLength(0); i++) { array2[i] = i+1; } range2-Value2 = array2; My QUESTION is: how can I change the addressing from "A1" / "E1" to R1C1 / R1C5. If I just replace the strings it fails. Hope someone can HEEEELP!!! Fizikus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Addressing in VBA | Excel Discussion (Misc queries) | |||
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Discussion (Misc queries) | |||
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Worksheet Functions | |||
Sorksheet addressing (I think) in '97 | Excel Discussion (Misc queries) | |||
two D addressing? lookup? | Excel Discussion (Misc queries) |