Re: sorting data in 2 columns on column 1

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Tom,

As allways : THANKS !!!
but i think i put my question a little wrong...

My data does not start in F1 but in F4.... and the length of the list is
dependent on the users input (can be 20 items, can be 50 items).

How can i adapt your code ?
Pierre

P.S. My data does not start in F1 but in F4.... and the length of the list is
dependent on the users input (can be 20 items, can be 50 items).


Tom Ogilvy wrote:
>Range("F:G").sort Key1:=Range("F1"), Header:=xlYes
>
>> 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
.

Relevant Pages