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.
Bookmarks