Excel Vba Get Worksheet Name. Related examples in the same category. changes the value of the Name property of the first worksheet in the first workbook of the Excel application Difference between Worksheets and Sheets in VBA. In the Excel worksheet view, you can name the worksheet whatever you want, but in the backend, it will respond to both the names - the sheet name and the code name.
To get the name of the current worksheet (i.e. current tab) you can use a formula based on the CELL function.
In this case, we want to find out of a particular sheet exists in.
VBA-Excel: Delete Blank Rows from Excel Work Sheet. The CELL function below returns the complete path, workbook name and current worksheet name. In the Excel worksheet view, you can name the worksheet whatever you want, but in the backend, it will respond to both the names - the sheet name and the code name.








