View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default sorting data in 2 columns on column 1

Range("F:G").sort Key1:=Range("F1"), Header:=xlYes

--
Regards,
Tom Ogilvy


"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:58bbf03d73d85@uwe...
Hi,

How can i, in vba, sort colum F and G on the value in column F.
Thanks,
Pierre

--
Message posted via http://www.officekb.com