How to return to a cell after sorting a spreadsheet.
 

Thanks Paul
Exactly what I was after - Is there a place on the toolbar to do this or a
keyboard shortcut?

Givvie

"Paul B" wrote:

Givvie, add this line of code at the end of your macro, it will select the
last cell in column A with data

Cells(Rows.Count, 1).End(xlUp).Select


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Givvie" wrote in message
...
After doing a sort via a macro, how do you get it to always return to a
cell
in the last row of data that was entered.
I have set up a macro that will sort rows of data from top to bottom in
date
entered order (current date being the last row of data entered) depending
on
what is entered into a particular coloum eg date out column.
The problem I have is because the macro was set up when there was only a
few
rows and now there are heaps it always returns me to the cell that was
selected at the time of doing the macro eg B6.
I am now entering data into row 580 and this row number is increasing each
time. After I do a sort I have to scroll down to my last row.

How to return to a cell after sorting a spreadsheet.
 

If your range contains no blank cells, select any cell in the desired
column, press END then the DOWN ARROW key.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Givvie" wrote in message
...
Thanks Paul
Exactly what I was after - Is there a place on the toolbar to do this or a
keyboard shortcut?

Givvie

"Paul B" wrote:

Givvie, add this line of code at the end of your macro, it will select
the
last cell in column A with data

Cells(Rows.Count, 1).End(xlUp).Select


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Givvie" wrote in message
...
After doing a sort via a macro, how do you get it to always return to a
cell
in the last row of data that was entered.
I have set up a macro that will sort rows of data from top to bottom in
date
entered order (current date being the last row of data entered)
depending
on
what is entered into a particular coloum eg date out column.
The problem I have is because the macro was set up when there was only
a
few
rows and now there are heaps it always returns me to the cell that was
selected at the time of doing the macro eg B6.
I am now entering data into row 580 and this row number is increasing
each
time. After I do a sort I have to scroll down to my last row.