Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Leith,
My purpose in this statement was just to move the cursor to A3 after the sort. Is it wrong? Thanks! --Randy "Leith Ross" wrote in message ... Hello Randy, REMOVE THIS: Range("A:A").Select USE THIS: ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Select Hope this helps, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=355849 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort Macro | Excel Discussion (Misc queries) | |||
Sort Macro | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) | |||
Sort Macro | Excel Discussion (Misc queries) |