Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort problem (one column)
Hi,
I found out that the warning has nothing to do with it. Now, I still get the waring manually and I can sort programmatically. I don't know what has changed? When I close the workbook and restart it, the sort cannot take place (Error code 1004 method Sort of class Range failed). The sheet is protected but that state does not affect the error. After doing some actions, at a sudden time, the command works. Please help, Jos Vens "Jos Vens" schreef in bericht ... Hi, I have some difficulties to sort one column. A warning prevents me to sort programmatically 'My code spParameters.[aCampus].Sort Key1:=spParameters.[aCampus], Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom when I sort manually, I get this message, which is described on the internet If you only want to sort part of the data, you have to select it first: 1.. Click on the column heading letter B to select that column 2.. Click on [Sort Ascending] - a warning message appears: 3.. Select Continue with the current selection - press <Return for [Sort] Since my sort is only on one colomn, everything is OK with the current selection. How can I surpass this warning programmatically? Thanks Jos Vens |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort problem (one column) - Solution
Sorry for bothering you,
it was the protection of the sheet that did not let me sort! Unprotecting the sheet lets my code run fine. Sorry. Jos Vens "Jos Vens" schreef in bericht ... Hi, I found out that the warning has nothing to do with it. Now, I still get the waring manually and I can sort programmatically. I don't know what has changed? When I close the workbook and restart it, the sort cannot take place (Error code 1004 method Sort of class Range failed). The sheet is protected but that state does not affect the error. After doing some actions, at a sudden time, the command works. Please help, Jos Vens "Jos Vens" schreef in bericht ... Hi, I have some difficulties to sort one column. A warning prevents me to sort programmatically 'My code spParameters.[aCampus].Sort Key1:=spParameters.[aCampus], Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom when I sort manually, I get this message, which is described on the internet If you only want to sort part of the data, you have to select it first: 1.. Click on the column heading letter B to select that column 2.. Click on [Sort Ascending] - a warning message appears: 3.. Select Continue with the current selection - press <Return for [Sort] Since my sort is only on one colomn, everything is OK with the current selection. How can I surpass this warning programmatically? Thanks Jos Vens |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort without including column headings in sort | Excel Discussion (Misc queries) | |||
Auto-Sort Won't Sort All Column Cells | Excel Discussion (Misc queries) | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions |