1) First of all it should read: XLUP and not X1UP.
2) Your - after correction - formula selects the last filled cell in a range.
I'm not sure I understood the rest of your requext...
Assuming that the last cell being selected. by the command - what do you
want to do from this point and on...?
Micky

--
והמשך/×™, ×*×�, לקרו×� ×�ת השורה הב×�×”:
***********
×�×� תגובתי עזרה לחץ/×™, ×*×�, על <כן בפס ×”×�ופקי התחתון!
***********
מיכ�ל �בידן
מ×*הל פורו×� "×�ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"Jeremy" wrote:

I have a formula stating Range("G5000").End (x1up).Select and am wanting to
add to this where in the selected cell you add 1 + the first cell up.

Thank you