How to make Sheet1 the same as a Cell in Excel

Heedtheadvice

Try changing the vba code lines:



after line …= "" then exit sub

Insert

Target = Format(Target, "Long Date")


This format will be then for example "April 17, 2004" and will be suitable for the sheet name.....from memory!

GunJack

Robj241 wrote: »

Unfortunately this comes up as an error.

The Cell E3 contains a date - 01/01/18 but it won't allow /

Is there a way round this?

Many thanks for your assistance.

yes, when you rename the sheet, use dashes instead of slashes.