Silly question?

F

Francis Hookham

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
 
F

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
 
M

MartinW

Hi Francis,

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

HTH
Martin
 
F

Francis Hookham

It's me age!

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

Thanks

Francis
 
M

MartinW

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
 
Top