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