Active Sheet name

[AlexanderBB]

Is the active sheet name available from the Target Object ?
Is yes it would save me sending both to a function.

 

[Trebor76]

Hi there,

Do you mean like this:

MsgBox Target.Worksheet.Name

Regards,

Robert

 

[plettieri]

Hi AlexanderBB

You might try this...I believe you can do this

Sub GetActiveSheetName()
Dim sheetName As String
sheetName = ActiveSheet.Name
MsgBox sheetName
End Sub

hope this helps

plettieri

 

[AlexanderBB]

Thanks... .worksheet.name was exactly it .

 

[Alex Blakenburg]

Just to give you some other ideas.
If your code is inside a Sheet Module then the keyword "Me" will refer to the Sheet
ie Me.Name will get you the Sheet Name
I had not thought of using "Worksheet" to get the Name and am more used to Target.Parent.Name
Note: ActiveSheet is the ActiveSheet regardless of any range reference.

 

[AlexanderBB]

I'm sending Target as Object into a class module. If I didn't need to send in the name as a 2nd argument it seemed a bit neater.
Will remember Me so refers to sheet or Form. Good to know.

 

[Trebor76]

Thanks... .worksheet.name was exactly it .

Thanks for letting us know and you're welcome