![]() |
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 |
Sort problem in shared excel file
|
All times are GMT +1. The time now is 07:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com