View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sonnich Jensen Sonnich Jensen is offline
external usenet poster
 
Posts: 9
Default Sorting a sheet in VBA

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