Hi there,
I would like to ask for help on how to resize based on the active cell location.
I need the macro to copy the last 20 rows (Jan) of my existing data to generate the same formulas for the next Month. This is the code I recorded/edited.
However, the problem seems to be that i cannot resize the activecells. Could you let me know how to rewrite the macro?
Thanks a million!
Myespooir
I would like to ask for help on how to resize based on the active cell location.
I need the macro to copy the last 20 rows (Jan) of my existing data to generate the same formulas for the next Month. This is the code I recorded/edited.
Code:
Range("A2").Select
Selection.End(xlDown).Select
ActiveCell.Resize(-21, 6).Select
ActiveCell.Activate
Selection.Copy
Range("A2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
However, the problem seems to be that i cannot resize the activecells. Could you let me know how to rewrite the macro?
Thanks a million!
Myespooir