Creating A Newsheet Macro Issue

Hi All,

I have the following code that some users are having issues with. I think it specifically relates to the " NewSheet = Trim(InputBox(Mesg, Title))" line.
The macro was developed by Corporate and seven years later they are saying it's not their problem. Any assistance would be greatly appreciated.
Thanks!

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

Please Login or Register  to view this content.

What do you mean by "issues"?

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

By the way this line of code

Please Login or Register  to view this content.

declares NewSheet as Variant, Title as Variant, and Mesg as String. Some people write lines like this and think they will all be String. That's poor coding style, but it does not appear to be causing a problem here.