ExcelBanter - Get VB object worksheetname

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Get VB object worksheetname (https://www.excelbanter.com/excel-programming/420886-get-vbulletin-object-worksheetname.html)

Trev B[_2_]

Get VB object worksheetname

Hi

Thanks in advance

I can obtain the worksheet name by ActiveSheet.Name
But I want the Excel object name for the worksheet.

I just can't find this in reference.

Thanks

Trev

Mike H

Get VB object worksheetname

Hi,

Do you mean the codename

ActiveSheet.CodeName

Mike

"Trev B" wrote:

Hi

Thanks in advance

I can obtain the worksheet name by ActiveSheet.Name
But I want the Excel object name for the worksheet.

I just can't find this in reference.

Thanks

Trev

All times are GMT +1. The time now is 09:22 PM.