| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative Range in a Formula
I have a relative range that I need to capture in a SUM formula, recording
the macro gives me this. Is there a way to capture the true range? This is what's in my SUB... ActiveCell.FormulaR1C1 = "=SUM(R[-66]C:R[-1]C)" Thanks!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Relative Range in a Formula
Never mind found it...
SUMMING A RANGE With ActiveCell Set ColRange = Range(.Offset(-1), .Offset(-1).End(xlUp)) .Formula = "=sum( " & ColRange.Address(RowAbsolute:=False) & ")" End With "Alex" wrote: I have a relative range that I need to capture in a SUM formula, recording the macro gives me this. Is there a way to capture the true range? This is what's in my SUB... ActiveCell.FormulaR1C1 = "=SUM(R[-66]C:R[-1]C)" Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative Range Reference in a sumifs formula | Excel Worksheet Functions | |||
| COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
| name range from absolute to relative | Excel Worksheet Functions | |||
| How to get relative range? | Excel Programming | |||
| Making a relative range in VBA | Excel Programming | |||
Hybrid Mode
