Combine a Variable and Constant Sheet Name in VBA

Hello,

I am using a macro to take a master sheet and break it out into sub sheets based on a parameter entered by the user. The code is then renaming the new sheets based on this parameter. I'd like to rename the sheet based on the variable parameter plus a constant value. For example:

If the data is:
Apple
Orange
Banana

I'd the sheets to be named Apple.Fruit, Orange.Fruit, Banana.Fruit.

Thank you for your help!

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer