Defining the name of a worksheet as a variable | Excel forum

Hello!

I have worksheets named as strings "DD MM YYYY" which I am trying to reformat and so that I can update a cell with the name from the last sheet in the workbook, in the format DD/MM/YYYY

Using variables is new to me, so I am sure it is something to do with my variable declaration.

The issue seems to be with my LSN variable where I want it to take the name of the last worksheet in my file.

Currently my code is as follows:

Sub UpdateEmailSummary()
'
' UpdateEmailSummary Macro
'
Dim LSN As String
Dim LF As Integer
Dim LM As Integer
Dim LR As Integer

LSN = Sheets(Sheet.Count).Name
LF = Left(LSN, 2)
LM = Mid(LSN, 4, 2)
LR = Right(LSN, 4)

Sheets("EMAIL SUMMARY").Select
Range("C3").Select
ActiveCell.FormulaR1C1 = LF & "/" & LM & "/" & LR

End Sub

Many thanks,
Toby