Steve Belsch
01-09-2020, 11:41 AM
Hi VBA Experts,
I was wondering if there is a faster way to copy paste formulas across multiple columns. This what I am doing now and it takes to long. I am just trying to copy and entire row and then paste the formula in the row below it.
For iCol = 21 To 73
Range(Cells(i, 21), Cells(i, 73)).Copy
Range(Cells(i + 1, 21), Cells(i + 1, 73)).PasteSpecial xlPasteFormulas
Next iCol
Thanks for the ideas.
Steve
I was wondering if there is a faster way to copy paste formulas across multiple columns. This what I am doing now and it takes to long. I am just trying to copy and entire row and then paste the formula in the row below it.
For iCol = 21 To 73
Range(Cells(i, 21), Cells(i, 73)).Copy
Range(Cells(i + 1, 21), Cells(i + 1, 73)).PasteSpecial xlPasteFormulas
Next iCol
Thanks for the ideas.
Steve