Is there a better way to write this?

[MarkK]

There is a VBA.Trim() function which removes both leading and trailing space characters from a string, but it seems fairly simple to test whether they are present.

debug.print "*" & var & "*"

 

[glasgowlad1999]

*AuditWorkSheet'

Was returned

 

[MarkK]

I'm not sure what that means. I don't see a trailing "*". But can we conclude there are no spaces in the name? I think so.

Is there any way you can make the call to RunMacro work? Hard-code a name you expect will work. Then, work backwards from there.