Name a worksheet using a variable

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

Please Login or Register  to view this content.

where name is my string but weirdly (to me) this names the sheet after my UserForm.

How can I name it after the contents of my string?

Many thanks,

Paul.

Oops....

I forgot to dim my variable and put some data in it.....

worksheet.name = name works...