| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell refs in formula
Dear All;
How do I reference cells in formulas? I need an example of VB macro that fills up the cell range C1000:C2000 with formulas so they show pairwise sums of A2000:A3000 and B3000:B4000 cells //from C++ for(int i=0; i<1000; i++) cellC[i+1000]=cellA[i+2000]+cellB[i+3000] Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell refs in formula
On 28 Apr, 04:57, "Boba" wrote:
Dear All; How do I reference cells in formulas? I need an example of VB macro that fills up the cell range C1000:C2000 with formulas so they show pairwise sums of A2000:A3000 and B3000:B4000 cells //from C++ for(int i=0; i<1000; i++) cellC[i+1000]=cellA[i+2000]+cellB[i+3000] Thanks in advance. try.... Range("C1000").FormulaR1C1 = "=SUM(RC[-2]:RC[-1])" Range("C1000").AutoFill Destination:=Range("C1000:C3000"), Type:=xlFillDefault |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell refs in formula
Perfect. Thanks for the lesson.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Formula Auditing give cell refs to other sheets? | New Users to Excel | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
| Why would a pasted formula not calculate the new cell refs? | Excel Worksheet Functions | |||
| Copying a formula with different sheet refs | Excel Discussion (Misc queries) | |||
| Variable Cell Refs | Excel Programming | |||
Linear Mode
