Dropping To The Bottom Of A Table

[jskrepak]

Well I confess to feeling very stupid right now. I recorded a simple sort function as a macro beginning with range A1 in my table. The sort works fine but it leaves me sitting at A1 when its done. I really need the macro to bring me to the next empty row at the bottom of the table so I can continue adding information.

I tried recording Ctrl/Shift > Down Arrow followed by Page Down and it seemed to work. Then I notice the macro simply recorded the range after paging down and locked it in. So now instead of being returned to A1, I'm returned to A784 even though my table has since grown past row 1000.

I want to ALWAYS be returned to the next row below the table (in column A) no matter how big the table gets. What am I missing here?

 

[mattrx731]

No promises, but this works on one of my macros to goto the last empty row...

Range("A" & Range("A" & Rows.Count).End(xlUp).Row + 1).Select

HTH
Matt O.

 

[jskrepak]

I like it so far.

Thanks