Sort Each Row seperately

[Steph]

Hello. I have a block of data (A5:Z2000). Each row represents data for a
specific individual. I know how code vba to sort a single row. How can I
have vba sort each row individually?

So in other words, I need to sort A5:Z5 in ascending order.
Then sort A6:Z6 in ascending order
And so on...So a looping sort?

Thanks in advance!

 

[VK]

Hello. I have a block of data (A5:Z2000). Each row represents data for a
specific individual. I know how code vba to sort a single row. How can I
have vba sort each row individually?

So in other words, I need to sort A5:Z5 in ascending order.
Then sort A6:Z6 in ascending order
And so on...So a looping sort?

Thanks in advance!

For example:

Sub SortRowsMakro()
totalrows = ActiveSheet.UsedRange.Rows.Count
For Row = 1 To totalrows Step 1
'
'Hear your sort steps for one row
'


Next Row
End Sub

Reg. VK