The below will refer the cells F10:F65536
=OFFSET(F1,9,0,65536-9,1)

'to sum that range
=SUM(OFFSET(F1,9,0,65536-9,1))

'VBA to refer the range.
Range("F10:F" & Rows.Count)

Msgbox Range("F10:F" & Rows.Count).Address


If this post helps click Yes
---------------
Jacob Skaria


"Jock" wrote:

Stating an absolute range can sometimes not be possible due to unknowns.
Using (F:F) for instance can be a useful alternative as it looks at the
entire column, not just part of it.
However, is it possible to specify a start cell to search down from?
i.e.(F$10:F) This q is for both formulae and vb.
Thanks,
--
Traa Dy Liooar

Jock