PDA

View Full Version : Solved: Required to copy and paste a formula to a column range



bananatang
07-29-2009, 01:01 AM
HI,

Need abit of help on this one.

I would like to have a macro that will copy the formula in Column C1 and then paste to all through the column until it reaches the last row in Column A1 as this column will contain an entry for all records in the data table.

Thanks

BT

Bob Phillips
07-29-2009, 01:14 AM
air coding


Dim LastRow As Long

With Activesheet

LastRow = .Cells(.Rows.Count,"A").End(xlUp).Row
.Range("C1").Autofill .Range("C1").Resize(LastRow)
End With

bananatang
07-29-2009, 07:40 AM
Thank you Xld.

BT