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