Copy Fomulas down
Sub Auto_Fill()
Dim Elastrow As Long
Dim Flastrow As Long
With ActiveSheet
Flastrow = Range("F" & Rows.Count).End(xlUp).Row
Elastrow = Range("E" & Rows.Count).End(xlUp).Row
Range("F" & Flastrow & ":G" & Elastrow).FillDown
End With
End Sub
Gord Dibben MS Excel MVP
On Sat, 28 Jun 2008 10:08:00 -0700, Ronbo
wrote:
I have data in columns A:E and corresponding formulas in F:G. Data is added
to columns A:E and I am trying to create a formula that will find the last
formula(s) in columns F:G and copy it down to the end of the data.
I have found numours ways to do this using a static reference in F & G, but
I have to use the last formula in the column to copy down.
Any help is appreciated.
Ronbo
|