Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting macro
I need to sort a column ascending upon closing the
workbook.. I got it started with an Auto_Close macro. However G2 contains my heading, G1 contains my title, and G3 is where my data starts, so I keep getting a debugging error. Sometimes it runs the sort without giving me a debugging error, but then it is moving the header row of A2:G2 below the data when it sorts. So instead of A2:G2 showing the column headers, the column headers are moved to A11:G11 and the data is sorted (correctly) in A2:G10. The column headers for H2:P2 stay in the same place. Thanks for the help, Beth |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting macro
Beth
Insrt a blank row between the title and the headings. Don -- "Beth Mc" wrote in message ... I need to sort a column ascending upon closing the workbook.. I got it started with an Auto_Close macro. However G2 contains my heading, G1 contains my title, and G3 is where my data starts, so I keep getting a debugging error. Sometimes it runs the sort without giving me a debugging error, but then it is moving the header row of A2:G2 below the data when it sorts. So instead of A2:G2 showing the column headers, the column headers are moved to A11:G11 and the data is sorted (correctly) in A2:G10. The column headers for H2:P2 stay in the same place. Thanks for the help, Beth |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting macro
See one more guess at your original post.
Beth Mc wrote: I need to sort a column ascending upon closing the workbook.. I got it started with an Auto_Close macro. However G2 contains my heading, G1 contains my title, and G3 is where my data starts, so I keep getting a debugging error. Sometimes it runs the sort without giving me a debugging error, but then it is moving the header row of A2:G2 below the data when it sorts. So instead of A2:G2 showing the column headers, the column headers are moved to A11:G11 and the data is sorted (correctly) in A2:G10. The column headers for H2:P2 stay in the same place. Thanks for the help, Beth -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Macro | Excel Worksheet Functions | |||
Help with Macro for sorting | Excel Worksheet Functions | |||
sorting using macro | Excel Discussion (Misc queries) | |||
macro for sorting | Excel Discussion (Misc queries) | |||
Macro for sorting different rows | Excel Worksheet Functions |