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

--
Regards
Frank Kabel
Frankfurt, Germany


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


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

Any help would be greatly appreciated.
thanks,
Scott


---
Message posted from http://www.ExcelForum.com/