Tab Title Macro

[Mike1w]

Below is what I am using to indicate the name of my tab

Please Login or Register  to view this content.

It works great but in another area of the worksheet I have a macro to reference another worksheet in the same workbook and bring in it's values based on the tab name indicated in the adjacent cell. (the code is below):

Please Login or Register  to view this content.

However when the sheet title in "A1" has a dash "-" involved and the tab name indicates that "-" the macro will not run it does some weird things, is there a way in the macro for the tab name to change any "-" to a "." in the tab name but keep the "-" in the "A1"? just a question because the "." will work in the tab name but I need the "-" in the sheet title name, any suggestions? Thanks

[antoka05]

You can try to use Replace instruction:

Please Login or Register  to view this content.

Regards,
Antonio