my macro is remembering specific range instead of from 1st to last

[Pam @ Joyce]

I need my macro to include shift+end+down arrow, to select from 1st to last
in a column, it does it once as the spreadsheet grows it only selects the
first range. Can someone pls help

 

[Pam @ Joyce]

Just seen I've posted this question to the wrong forum I needed Excel.