Hello All,
I was wondering how I can copy the name of a sheet onto a cell on another sheet. The syntax is like this....
With .Sheets(S)
'Final 1
FinalS1 = wsS.Cells(Rows.Count, 1).End(xlUp).Row
wsS.Cells((FinalS1 + 1), 3).Value = "NEED THE NAME of .Sheets(S) here"
End With
Please help and thank you in advance!!
Alexis
Bookmarks