As an example of my dilemma, I simply want a Macro that when executed, copies the contents from the cell immediately above the active cell and moves one cell to the right. I record my macro in cell b2 and I get:
Range("B1").Select
Selection.Copy
Range("B2").Select
ActiveSheet.Paste
Range("C2").Select
Obviously, each time I execute the macro, I copy the same exact data from B1 to B2.
I know I can edit the macro to use ActiveCell.offset, but can I get it to work by reference while recording with keystrokes?
Thanks for any help you may offer.
Range("B1").Select
Selection.Copy
Range("B2").Select
ActiveSheet.Paste
Range("C2").Select
Obviously, each time I execute the macro, I copy the same exact data from B1 to B2.
I know I can edit the macro to use ActiveCell.offset, but can I get it to work by reference while recording with keystrokes?
Thanks for any help you may offer.