ActiveSheet.Name

  • Thread starter Thread starter EXCELMACROS
  • Start date Start date
E

EXCELMACROS

Hello,

I appreciate if someone can help me with a function that grabs only a
portion of the sheet name. For example, I'm using

ActiveCell = ActiveSheet.Name, then I'm using formula colname =right(mycell,5)

is there a way that I don't have to put the name of the sheet in the SS,
just grab it directly from the tab and storage it ?

Thank you,
 
You c an use a simple UDF

call with =GetTab()



Function GetTab()

GetTab = ActiveSheet.Name

End Function
 
Thank you, from there I'm actually doing the following and it is working
without having to print the tab in the actuall SS

myinfo = Mid(ActiveSheet.Name, 19, Len(ActiveSheet.Name) - 23)

thanks a lot
 
You don't need the len ght in the formula. The worksheet function MID
requires a lenght, when you use MID in a macro the length parameter is
optional

myinfo = Mid(ActiveSheet.Name, 19)
 
Back
Top