Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort problem in shared excel file
Hi,
I do have a problem with a shared excel file. Althought I am single using this shared file I constantly get an error 1004 when I run a macro to sort. The macro looks like this: Sub Sorteer() Range("M11:AE55").Select Selection.Sort Key1:=Range("M11"), Order1:=xlAscending, Key2:=Range("N11" _ ), Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom Range("M11").Select End Sub The error message is in Dutch but when I translate it should be something like: "For this operation all merged cells must have the same size" In the sort range are no merged cells. ================= When I do it manualy, with only 2 cells, I get the same error message. What is my problem??? Thanks in advance Jan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort problem in shared excel file
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with shared excel file. | Excel Discussion (Misc queries) | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |