I'm writing a macro in excel How do I copy and paste an entry into the next available row in a list i.e. Details are on a different sheet so I copy and paste into the table on another sheet where Rows 1 to 10 are currently empty - Macro will add first set of details into row 1 Next time macro runs it will add the details into row 2 next time macro runs it will add details into row 3 and so on. Every time I try it the details end up in the same place - I need to be able to somehow use "End + 1" but don't know the syntax. Cheers,
Dunt matter, sorted it For anyone interested, I replaced the line after the line "Selection.End(xlDown).Select" with "Cells(ActiveCell.Row + 1, 2).Select" Top qulaity boring stuff!
