Sorting variable range left to right

Hello there,

I have recorded the following code that sorts from left to right. How do you make the hard coded ranges ("A1:EX1") (columns) and ("A1:EX1193") (rows) variable?

Please Login or Register  to view this content.

Regards,
shinobi

Great question. In what way do you want to make them variable? Specify in inputbox? Until the last used row and the last used column?

Hi stnkynts,

Until the last used row and the last used column.

There are many variations to obtain the last used row and the last used column. I will show you the two more common ways, one for last row, and the other for last column.

Please Login or Register  to view this content.

With that in mind you should be able modify the 2 lines in your code accordingly

Please Login or Register  to view this content.

Thanks for the tips stnkynts. I should be able to do it now. Sort left to right seems a bit more tricky than top to bottom.