Applying a macro to a selected range.

[roshanvmech]

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.

[Richard Buttrey]

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.

[6StringJazzer]

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.

[6StringJazzer]

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..."