Hi all,
I tried to record a macro that would allow me to select the last cell with data in column J and K. And then "DragCopy" this data down into the cells beneath them.
So from J22:K22 to J23:K23... the next time the macro is executed i want it to copy from 23 to 24 instead.
____________
The problem is the following code:
Range("J10").End(xlDown)
can't be edited to include K10. "J10:K10" doesnt work, it selects just the J.
and
the DRAGCOPY code generated by the macrorecorder, can't be edited to do what i want because i dont know how to edit the code to include the Offset(1, 0).Select in the destination
Please help
I tried to record a macro that would allow me to select the last cell with data in column J and K. And then "DragCopy" this data down into the cells beneath them.
So from J22:K22 to J23:K23... the next time the macro is executed i want it to copy from 23 to 24 instead.
____________
The problem is the following code:
Range("J10").End(xlDown)
can't be edited to include K10. "J10:K10" doesnt work, it selects just the J.
and
the DRAGCOPY code generated by the macrorecorder, can't be edited to do what i want because i dont know how to edit the code to include the Offset(1, 0).Select in the destination
Please help