macro to sort using relative references

[kent97]

Dear all,

ScreenHunter_041.jpg

I want to write a macro to sort using relative references.
When I put the cursor at H4 and start the macro, it would sort Row 4:Row 24 using H4:H24 as index.
When the cursor is at O4, it sorts using O4:O24 as index.

The problem I meet is that, although relative relative mode is set, it always starts at H4 at which the cursor I first put during recording.


Thank you

[antoka05]

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

[kent97]

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Yes! It works as what I want.
Thank you Antonio

[kent97]

Dear Antonio,

I found your macro only sorts the area from cells A4:P24, but I want to sort all the rows from Row 4 to Row 24.

Amendment : I got it, it may sort the entire row after the workbook is saved before running the macro,

[antoka05]

I hope that this code can help you:

Please Login or Register  to view this content.

Regards,
Antonio

[kent97]

I hope that this code can help you:

Please Login or Register  to view this content.

Regards,
Antonio

Yes, the Macro may sort the entire row after amended. But I find it also sorts Row 1 to 3, I expect these 3 rows remain intact, only sort w.e.f. Row 4.

Thanks