kwillis74
01-27-2016, 09:22 AM
Hi All
I've a bit of a wierd problem that i'm hoping someone can help me with.
I have the following code that runs a sort in a 2003 workbook.
Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Key2:=Range("A2") _
, Order2:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False _
, Orientation:=xlTopToBottom
In 2003 this works fine, however when run in 2010 if i add a new row of data at the bottom of the selected range (before running the macro) that new row gets sorted to the correct position but it has a row height of zero. To make it more infuriating if i use different data it works fine.
Has anyone come across something like this before?
Thanks
I've a bit of a wierd problem that i'm hoping someone can help me with.
I have the following code that runs a sort in a 2003 workbook.
Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Key2:=Range("A2") _
, Order2:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False _
, Orientation:=xlTopToBottom
In 2003 this works fine, however when run in 2010 if i add a new row of data at the bottom of the selected range (before running the macro) that new row gets sorted to the correct position but it has a row height of zero. To make it more infuriating if i use different data it works fine.
Has anyone come across something like this before?
Thanks