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)


"EXCELMACROS" wrote:

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
--
Thank you...


"Joel" wrote:

You c an use a simple UDF

call with =GetTab()



Function GetTab()

GetTab = ActiveSheet.Name

End Function

"EXCELMACROS" wrote:

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,
--
Thank you...