[RESOLVED] Excel - how to xlUp ?

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)

Never mind - friday afternoon - I'm working in Powerpoint linking to an Excel so - xlup hasn't been defined (duuuuh!)

Sorry people :)

do u mean to find last used row? if yes

Code:

---

Dim LastRow as long
LastRow = Cells(Rows.Count, "A").End(xlup).Row

---

Yup thats what I was doing - but forgot I am in Powerpoint, so xlup isn't defined (doh!). Works fine - thanks for the assist!