Hi
I have the following macro and it does add lines below the last line of the worksheet when I run it but it also copies and pastes the data and I just need the formulas to be pasted so the new lines are blank
Any Ideas?
I have the following macro and it does add lines below the last line of the worksheet when I run it but it also copies and pastes the data and I just need the formulas to be pasted so the new lines are blank
Any Ideas?
VBA Code:
Sub Insert_300_Rows()
Dim LR As Long
LR = Range("AB" & Rows.Count).End(xlUp).Row 'detect last used row in column AB
Rows(LR & ":" & LR + 300).FillDown 'paste down formats & formulas (if any)
End Sub