VBA to save file as name of tab & date in cell

Hi,

I want to add some code to my macro which will save the file as the File name & date from cell B10.

Any ideas on how to do this?

Try

ThisWorkbook.SaveAs Filename:=Range("B10").Value & ".xlsx", FileFormat:=xlNormal

Please click the * below if this helps

Many Thanks for your help.