Hi,

I'm really stuck, tried various things, and none worked.

I have a data table that I add data to it constantly and automaticly with a diffrent Macro

the data I add is on columns A to P, and on columns Q to V there are formulas.

I need the Macro to AutoFill the formulas in columns Q to V to the rows added..

Among many things, I tried this:

dim lastrow as Long

lastrow = Range("A" & Cells.Rows.Count).End(xlUp).Row

Range("Q" & Cells.Rows.Count).End(xlUp).Select
Selection.AutoFill destination = Range("Q" & lastrow)


but it doesnt work..
Any ideas? I really need this to work...

Thank you!