T O P I C R E V I E W |
wojtek_ |
Posted - 09/20/2017 : 3:20:37 PM Hi, I have a very basic question which actually I cannot find the answer. How to get a name of active worksheet?
Usinge %E variable I get "[shortbookname]shortworksheetname" but I need only "shortworksheetname". |
2 L A T E S T R E P L I E S (Newest First) |
wojtek_ |
Posted - 09/20/2017 : 4:43:32 PM Thank you very much!
Best regards, Wojtek |
nick_n |
Posted - 09/20/2017 : 4:23:09 PM Hi,
string strWorkSheetName$=page.active$; //if you need name of sheet int iWorkSheet=page.active; //if you need Sheet index
Best,
Nikolay |
|
|