I want to get the name of only the current active worksheet present in an excel workbook.
Is there any way to do that without using macro.
Like, in the screenshot below, the Sheet1 is active.
screenshot below, the Sheet2 is active.
So, for number one, I need this active sheet names.
Do you have any insight in this case? if yes, please help.
Thanks & Cheers