Please can anyone help.
I am trying to paste a sheet name into a cell on a different sheet, but my sheets are named "Nov 04", Dec 04" etc, and excel keeps changing the name into a date, which returns "Nov-05"
I have tried making a variable (Nme) as String, and I have tried changing the numberformat of the cell to "Text" and "General", but neither of these work
The following is the part of the macro I have used
Nme = tsheet.Name
Range("A1") = Nme