I have created a macro that sorts a set of numbers in a row from lowest to highest in a single sheet. I paired this macro to a shortcut so that it can be applied at will to any sheet in the workbook. However, the macro only seems to sort the values in the sheet which it was created and not in any of the other sheets. The macro doesn't give any errors and runs through the whole code, but the values in the other sheets are not sorted after it has been run. The data was originally located on different rows, but rows were added and then subsequently hidden in order to ensure that it was all in the same row and column (this was done outside of the macro). Is there a way for me to create a single macro with a shortcut key that will apply to all of the sheets?
Bookmarks