Dan Wilson
Well-known Member
- Joined
- Feb 5, 2006
- Messages
- 507
- Office Version
- 365
- Platform
- Windows
Good day. I am running Excel out of Office 365 (updated) and Windows 10 Home (updated). I have a worksheet that contains Columns A thru P and almost 3,000 Rows. There are eight macros to sort the data different ways. Each of the Macros has a one-word title to identify it. For example - Numb equals a sort by number, Year equals a sort by year. Is there some code that will allow me to place the name of the Macro in cell Q1 to identify the way the data is sorted when the Macro is done? Cell Q! would then be changed by each Macro as it runs. The entire worksheet uses Freeze Top Row. Thank you for any response.