Help with a Macro

[Dan Wilson]

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.

 

[Joe4]

Why not just add a line to the end of each macro code telling with the name of the macro in it, i.e.
at the end of your "Numb" macro:

Range("Q1")="Numb"

at the end of your "Year" macro:

Range("Q1")="Year"

etc

 

[kvsrinivasamurthy]

In Numb macro at the end add line

Range("Q1")="Sorted by number"

In Year macro at the end add line

Range("Q1")="Sorted by year"

 

[Dan Wilson]

Why not just add a line to the end of each macro code telling with the name of the macro in it, i.e.
at the end of your "Numb" macro:

Range("Q1")="Numb"

at the end of your "Year" macro:

Range("Q1")="Year"

etc

Good day Joe4 and thank you for responding. I had to do a bit of experimenting to get it right, but everything is working as wanted. The more I use Excel, the more I love it!

In Numb macro at the end add line

Range("Q1")="Sorted by number"

In Year macro at the end add line

Range("Q1")="Sorted by year"

Good day kvsrinivasamurthy and thank you for responding. Your response was the same as Joe4 except for more lengthy labels. I had to some expermenting to get it to work, but All is working as wanted.

 

[Joe4]

You are welcome,
Glad I was able to help.

 

[kvsrinivasamurthy]

Instead of just name of macro the label shows what is done.