I am new to MS VBA.
I have recorded a simple macro that moves data from one cell location to another cell location within the same sheet.
I do not wish the active cell to be static, nor do I wish the destination cell to be static. I want them to be relative to the initial cell that is selected.
How do I change the instructions in the macro to reflect this? ie if there is data in cells C4, C5, C6; C5 is selected, the data is cut and pasted into D4; then C6 is selected, the data is cut and pasted into E4.
If I were to select C11 and run the macro, the data in C11 is cut and pasted into D10; then C12 is selected, the data is cut and pasted into E12. etc
How can I make the cell addresses in the macro general ie ("C53") becomes active cell instead of a named cell?
Thank yoy
Bookmarks