OFFSET Syntax

S

Scott1523

I recorded a simple macro that places the subtotal formula in a selecte
cell. Is there a way to use OFFSET to force the formula to star
reading 2 lines below the selected cell and to the end of the colum
data?
Here is what I am currently using but it doesn't work correctly if th
selected cell is below the 2nd row.


Selection.FormulaR1C1 = "=SUBTOTAL(9,R[2]C:R[65535]C)"

Any help would be greatly appreciated.
thanks,
Scot
 
F

Frank Kabel

Hi Scott
not really sure what your issue is? Could you give an example of the
expected formula in a given cell location?
 
S

Scott1523

If I place this formula in row 4, I will receive a circular referenc
error (because the current formula always begins reading from row 2).
I need a formula that is not based on a specific cell reference, bu
rather a relative position.
Hope this helps define my problem a little better.
Thanks again for all your help.
Scot
 
Top