Had a date in a cell, stored it to clipboard to use as a sheet tab name. How come I can do this manually, but not when it is run as a macro? Please advise and thanks
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Open in new window
You could do it all in one line if you wish:Open in new window