Macro code for dropping to next empty cell
Hi
I am trying to get a macro to copy data from one cell & paste it onto the
bottom of a list, however my current attempt just keeps overwriting one cell
as my current programming seems to have selected an actual cell reference. I
recorded the macro of me copying, then higlighting the cell at the top of the
listing column, hitting CTRL+DOWN CURSOR then down cursor again before
pasting. I thought this would leave the code to always drop to the bottom of
the list & then go one cell further, but this appears not to be the case!
Does anyone know a better (i.e. functioning!) way to program this?
Many thanks in advance, if you need any more info please reply.
cheers
jb
|