China Naming Network - Ziwei Dou Shu - How does VBA excel automatically get the name of the current worksheet? The statement is as follows
How does VBA excel automatically get the name of the current worksheet? The statement is as follows
Dim fname as a string
fname=thisworkbook.name
You can get the name of the current workbook.
Gets the name of the current worksheet.
fname=activesheet.name