Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a macro to see the next available empty cell | Excel Discussion (Misc queries) | |||
Macro help - copy a cell down | Excel Discussion (Misc queries) | |||
Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |