Thank you so much CoRrRan.

It's worked a treat.

Much obliged.

Regards

Jon

On 25 Jan, 13:39, CoRrRan wrote:
If you want to concatenate different strings and string-variables, use
the ampersand (&) instead of the plus-sign (+).

Thus:

filesavename = "EFF " & Worksheets(1).Range("E7") & " " & Worksheets
(1).Range("E9") & etc...

HTH, CoRrRan