Macro for organizing excel points

Originally Posted by schalla

Hi,
On last question. In the code you gave me, I should be selecting the rows and then running the macro. Instead can the macro automatically select rows starting from row22 to the #of rowcount.
Thanku

No you shouldn't be selecting anything the macro already runs from Row 22 to the last used row.That is what this row says

For Each RN In Range("B22:B" & LR)

. It says for each row number starting at row 22 till Last row in column B.