Hi All,
I have a macro which sorts data within a cell. This is working perfectly fine but the only problem with this is that it works only for a single which is selected. How can I apply this macro to range of cells I select using a mouse. Any help is much appreciated!!!.
Please Login or Register to view this content.
Hi,
Are you able to share the workbook with us and describe in a narrative what you want to do.
What is QuickSort? I see no definition.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
The problem seems to be that in sub SortVals you are operating on ActiveCell throughout the code, instead of the cell that is being passed in as an argument. So you are going to sort the upper-left cell of Selection over and over again. See changes in red.
Please Login or Register to view this content.
Thanks for the rep! If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved.
Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks