Rescue name a sheet

[Orkito]

Hi, I'm using a macro and I ask to the user that select a range to paste some result. But I need rescue de name of de sheet where the user selected the range. How can I do this?

thanks

 

[JoeMo]

If the user's range is selected try:

selection.parent.name

to get the name of the sheet the user's selection is on.

 

[Leith Ross]

Hello Orkito,

You can return the name of the worksheet from a Range object using the Parent property like this...

 '  This assumes the selection is a Range
    WksName = Selection.Parent.Name