unknown column length

  • Thread starter Thread starter Jock
  • Start date Start date
J

Jock

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,
 
rng = Cells(Rows.Count, "F").End(xlUp).Row

with Range("F10:F" & rng)
.......
end with
 
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
 
Back
Top