Hi.
I have formulas from columns A to AX on this worksheet. I want to copy them from rows 2 to 52000. I have written a macro to do this, just an usual
Sub copyrows
Range("A2:AX2").copy Range("A3:AX52000")
End sub
but, this takes about 2 or 3 minutes.
Similarly, I have set up a delete row macro to reverse the above
sub deleterows()
Range("A3:A52000").clearcontents
End sub
but this takes a minute or so.
Any ways of speeding this up? It is particularly annoying since I have put these codes in the workbook open and workbookbeforesave place.
Thanks,
RET79
I have formulas from columns A to AX on this worksheet. I want to copy them from rows 2 to 52000. I have written a macro to do this, just an usual
Sub copyrows
Range("A2:AX2").copy Range("A3:AX52000")
End sub
but, this takes about 2 or 3 minutes.
Similarly, I have set up a delete row macro to reverse the above
sub deleterows()
Range("A3:A52000").clearcontents
End sub
but this takes a minute or so.
Any ways of speeding this up? It is particularly annoying since I have put these codes in the workbook open and workbookbeforesave place.
Thanks,
RET79