Silly question?



Just as one can sort a range up or down by this or that column, can one sort
a range this way or that way by this or that row?



I see no way of doing this but need to sort a schedule in this way as part
of a macro.



Francis Hookham

Hi Francis

Yes you can, Data>Sort>Options>Sort Left to Right

--
Regards

Roger Govier


"Francis Hookham" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Silly question?
>
>
>
> Just as one can sort a range up or down by this or that column, can
> one sort a range this way or that way by this or that row?
>
>
>
> I see no way of doing this but need to sort a schedule in this way as
> part of a macro.
>
>
>
> Francis Hookham
>
>

Thanks Roger - I should have looked further.

Early days but I might want to sort right to left but a quick macro try did
not work:

Selection.Sort Key1:=Range("B5"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight, _
DataOption1:=xlSortNormal

changed to:

Orientation:=xlrighttoleft,

failed.

OK - I shall have to live with it in the unlikly event that I shall need
it - at this stage it is of academic interest.

Francis

"Roger Govier" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Francis
>
> Yes you can, Data>Sort>Options>Sort Left to Right
>
> --
> Regards
>
> Roger Govier
>
>
> "Francis Hookham" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Silly question?
>>
>>
>>
>> Just as one can sort a range up or down by this or that column, can one
>> sort a range this way or that way by this or that row?
>>
>>
>>
>> I see no way of doing this but need to sort a schedule in this way as
>> part of a macro.
>>
>>
>>
>> Francis Hookham
>>
>>
>
>

Hi Francis,

Left to Right>Ascending sorts Left to Right
Left to Right>Descending sorts Right to Left

HTH
Martin

It's me age!

I should have thought of that - I'm just not as sharp as it was!

Thanks

Francis

"MartinW" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Francis,
>
> Left to Right>Ascending sorts Left to Right
> Left to Right>Descending sorts Right to Left
>
> HTH
> Martin
>

Yeah! Tell me about it!

A mate of mine says "If yuo've got a problem, run it by a kid, they'll get
you back on track!".
I think he's pretty right, we tend to step over the basics before we even
start looking.

Cheers
Martin