Macro selecting wrong cell range

[Josh]

I track orders in excell, when new orders are entered at the end of
the day I open the file they are entered into copy & paste at the
bottom of mine. I recorded a macro to do this for me but it does not
go to the end of the list to paste the new orders it goes back to the
same cell that was selected when the macro was recorded. (I press Ctrl
down to go to the end of the list, which was row #7325 when I recorded
the macro & that is the cell it goes back to)

How do I have the Macro go to the end regardless how long the list is?


I have the same problem selecting the cell range to copy (again
Shift+Ctrl+down)
to hilight all of the list but when I edit the macro it is calling for
a specific cell range so if the next day has more orders, some of the
ones at the bottom will not get coppied.


Thank you for your help

 

[Bob Phillips]

Assuming that you are looking at column A

Cells(Rows.Count,"A").End(xlUp).Offset(1,0).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)