Hi,


I used to use Range.end(xlUp) to move like pressing End button and up, but via code.

In 2010, xlUp no longer exists. So uh... how do I use the .end properly?


(weirdly all my old code running with the value in xlup still work fine from Access/Excel pre 2010)