Getting worksheet name from target object

[AlexanderBB]

I thought you could get this, including the full address but can't find it.
Is it possible?

 

[Micron]

Maybe you want
MsgBox ThisWorkbook.ActiveSheet.Name
or
Target.Address

 

[StephenCrump]

Target.Worksheet.Name would be better ....

Target is not necessarily in the ActiveSheet.

 

[AlexanderBB]

I was using ActiveSheet,name but am passing Target to various functions and wanted to use that,
And just remembered! Target.Parent.Name

 

[Micron]

Target is not necessarily in the ActiveSheet

But it is if it's driven by SelectionChange event?

 

[Alex Blakenburg]

As @Micron pointed out typically when you use Target you are using if in a Worksheet Event and it that is it the case the below will work.

Me.Name

 

[Trebor76]

Isn't this virtually the same question you asked here a couple of weeks ago?

 

[Micron]

Looks the same to me, and that one is marked as solved, no less.

 

[AlexanderBB]

Yes, I thought I'd found it somewhere.

 

[MARK858]

Yes, I thought I'd found it somewhere.

If you click Find threads and then Your threads it will bring up all the threads you have created