I have been working on code to copy and paste from one worksheet to another. The data that I need to copy will always be at A1:E1
, however, I need to always paste one row below. I will run it everyday, so for instance if today I paste on cells A1:E1
, then tomorrow I would need to paste on A2:E2
and on the next day A3:E3
... I wrote the code below which works but is not as dynamic as I need it to be. I would appreciate your help
Thank you
Sub Copy_range()
Worksheets("Dividends").Range("A1:E1").copy
Worksheets("Draft").Range("A1:E1").PasteSpecial
End Sub
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…