Sure, eg. replace
range("F3:F6") with
range(cells(3,6),cells(6,6))
or somewhere in the macro  do something along these lines:
myrange = range(cells(3,6),cells(6,6))
and use
myrange
in place of
range("F3:F6")
in the linest formula.