Excel Move ActiveCell Down

[RAxel]

Ok, basically I have a column that contains numbers. I was able to get to the bottom of the column by using the End(xlDown).Select property. All I want to do is to make the ActiveCell two cells below. So I'm staying in the same column, but move down two rows so I can sum the total. Beginner question, but I can't figure it out Thanks

 

[AnotherHiggins]

Have a look at Offset. Something like:
End(xlDown).offset(2,0).Select

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[RAxel]

I forgot to mention, this macro will be used on multiple excel files, so I can't hard code where to put the total. That would be to easy It'll change for every file. Thanks

 

[RAxel]

hey hey, thanks man. Ask and you shall receive eh?