Formula for naming tabs

[mremmenga]

Is it possible to make a macro that automatically names a tab based on cells in that tab. I built a macro that automatically copies and pastes a template into a new tab and I would like that tab to concatenate cells b1 and b2 and make that the name of the new tab.

I'm sure this would require some advanced Macro, but if its possible to do with a simple formula that would work too.

Thanks in advance for the help!

[royUK]

ou cannot use a formula to do this. Code would not be difficult, but how will you enter the values in the cells? They must be different each time or else you will have problem.

Please Login or Register  to view this content.

[mremmenga]

That worked perfectly, except some of the values that I will enter make the tab more than 31 characters. Is there anyway to just take the first 31 characters combined in the two cells?

Thanks.

[royUK]

Try

Please Login or Register  to view this content.