VBA code to sort data in numerical order

[Mr.Castle]

I need to sort a bunch of data in numerical order. Cells A6:A29 there a list of numbers related to B6:R29, cell A6 is related To B6:R6 and so on. I need a VBA code to sorts those rows in numerical order?

Example:
Example:

A B C .... R
1 CAR DOG HOUSE
3 BIKE CAT DOOR
9 GREEN BLACK ORANGE
2 GIRAFE PURPLE TREE



Result:

A B C .... R
1 CAR DOG HOUSE
2 GIRAFE PURPLE TREE
3 BIKE CAT DOOR
9 GREEN BLACK ORANGE

[CK76]

Why VBA? At any rate you should be able to get base syntax using Macro Recorder.

Please Login or Register  to view this content.

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[Mr.Castle]

Yes , the code worked

Thank you Greg

[Greg M]

Hi again,

Many thanks for your very prompt feedback.

You're welcome - glad I was able to help.

Regards,

Greg M