Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto filter run from a macro will not do the same as when done manually.
I have a sheet that on running the macro, pulls in certain data from
the master page and formats it for printing a display. The last item in the macro is to sort one of the columns in ascending order. Most of the macros are recorded from screen actions. From the screen the autofilter sort ascending works fine, however when I record it, I get one of two problems... 1. If I do not edit the macro, it sorts the data, but moves everthing up one line (in this case into the colum headers box, row 9) 2. If I change the selection reference to the cells below (B9:P500) - (B10:P500) it then fails to sort the first row of data into an ascending order. (PS the first row of data is actually on row 10, row 9 is the bottom of the column headers row). Is this a glitch, have I done something wrong??? Any pointers would be much appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn on Auto Filter?? It is grayed out. | Excel Discussion (Misc queries) | |||
Cell protection & Auto Filter | Excel Worksheet Functions | |||
Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) |