Thread: sort a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maileen[_2_] Maileen[_2_] is offline
external usenet poster
 
Posts: 9
Default sort a range

Hi,

I have a table where A1 and B1 contains respectively "Software" and
"Amount".
I would like to sort range (A2:B10) based on ascending sorting of Software.

I tried several things with range("A2:B10").Sort(Key1:=Range("A1")) but
nothing works...

could you help me please ?
thx,
Maileen