Hi all,
Part of a macro I'm working on triggers an event which imports a work sheet.
I could end up with as many as ten worksheets being imported.
I would like to name each one using a string variable as they are imported.
I've tried
where name is my string but weirdly (to me) this names the sheet after my UserForm.![]()
Please Login or Register to view this content.
How can I name it after the contents of my string?
Many thanks,
Paul.
Bookmarks