Re-naming a sheet, works but with errors

[Barttm888]

Hi all,

This is a part of code that changes a sheet name when copied. The name change has todays date and references a particular cell value on the original sheet. (F22) This sort of works, (Date comes across correct) but the value in cell F22 is quite a bit different. (Made up of numbers and letters)

Sheets("Master Template").Name = Format(Now(), "dd-mm-yy" + Sheets("Master Template").Range("F22"))

Any help is greatly appreciated.

Cheers Bart.

[JosephP]

you're a little off with the parentheses ;-)

Please Login or Register  to view this content.

[Barttm888]

Hey Joseph.

Thanks buddy, works a treat. Still trying to get my head around VBA.

[JosephP]

you're welcome :-)