| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I sort using column headings, in a macro, not "a1"
I have written a macro which includes a sort.
Problem happens when I delete a column and then run the macro. The macro automatically sorts on original column. Can I use the column heading ie SURNAME to sort. This would be the same heading after I delete a column, thus solve my problem. Many thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort 2 column in the same time "" as dictionary "" | Excel Worksheet Functions | |||
| Missing sort ascending or descending when go into "data" "sort"? | Excel Discussion (Misc queries) | |||
| SORT a column of Texts to follow another "EXACT" order | Excel Discussion (Misc queries) | |||
| Adding "letters (column headings)" | Excel Discussion (Misc queries) | |||
| HOW CAN I SORT A "RANKED" COLUMN WITHOUT LOSING THE FORMULA? | Excel Worksheet Functions | |||
Threaded Mode
