Maybe you want to sort both columns A and B???

sh2.range("a:b").sort .....



On 10/24/2011 10:22, Sonnich Jensen wrote:
Hi

I seem to have problems with this - I have a sheet of 2 coloums as

A = string, B = number, given as =1+2+3+.....

Now, I want to sort by the number, therefo

sh2.Range("B:B").Sort Key1:=sh2.Range("B:B"), Order1:=xlAscending,
Orientation:=xlSortRows
sh2 = worksheet

However, that does not really work.... what do I do wrong?

WBR
Sonnich

--
Dave Peterson