VBA/Macro to copy down a formula to row indicated in cell with formula

[kwest3904]

Need VBA/ macro that will copy a formula from a cells N2:AC2 into N3: N??? with the ??? being row number determined by a formula in O1

For example, if O1 has value 200, it would copy N2:AC2 to column N from rows 3 to 200

Tried the below based on similar questions and answers but neither works.

Range("N3:N" & Range("O1").Value).Formula = Range("N2:AC2").Formula

Range("N2:AC2").AutoFill Destination:=Range("N3").Resize(Sheets("E123 COMMZ").Range("o1").Value, 1)

The data is in tab named 'E123 COMMZ'

Thanks!

 

[Joe4]

Welcome to the Board!

Try this:

Range("N2:AC2").Copy Range("N3:N" & Sheets("E123 COMMZ").Range("O1").Value)

 

[mohadin]

Or May be

Range("N3:N" & Sheets("E123 COMMZ").Range("O1").Value).Formula = Application.Transpose(Range("N2:AC2").Formula)