For Next Loop - Sort Each Row Left to Right

[vba_beginner]

Hello,

I have a range of cells A1:D5 with letters from the alphabet - there are no column or row headers. I'd like the following code to start with Row 1 (A), sort the letters in that row from Left to Right, then go to Row 2 (B), repeat the same sort, and so on until all 5 rows are sorted.

The following piece of code I've written will sort all 5 rows, but only based on what I set Key1 to. In it's current format, I thought it would have interpreted Cells (1,1) as the first cell in each row, but apparently it's being interpreted as only cell A1.

Can someone please suggested a possible solution so that each row is sorted one-by-one? Thank you.

Please Login or Register  to view this content.

[Norie]

Instead of Rng.Rows.Cells(1,1) try Rw.Cells(1,1).

[BigBas]

You're actually quite close. In the loop, RW references the range being sorted, so you do not need to use Rng. Try the following and report back.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[vba_beginner]

Hi Norie, I tried your suggestion, but this did not work. In my original code, the 1st row would sort alphabetically and all other rows would follow that same order. For example, imagine rows 1 and 2 looked like this:

Row 1: D C B A
Row 2: A B C D

After I run my code, the rows would sort according to Row 1, Cells (1,1), and appear as such:

Row 1: A B C D
Row 2: D C B A

Using your suggestion, the reverse happened and row 2 was sorted alphabetically whereas row 1 was sorted according to the original order of letters in row 2.

[vba_beginner]

Hi BigBas, your slight tweak to Norie's suggestion was the last piece of the puzzle. The code now works! All the rows have been sorted alphabetically. Please see the correct code below (note: it is the same code BigBas posted above). Many thanks to you all!

Please Login or Register  to view this content.

[vba_beginner]

To clarify what piece of the code changed, please see below:

Original code:

Please Login or Register  to view this content.

Correction to code

Please Login or Register  to view this content.

[BigBas]

No problem. Always keep in mind that while you're in a loop, reference the variable being used in the loop and not the entire Range object.