Excel assign copied sheet name as variable
- by rach-90
I'm trying to copy an existing sheet in my workbook and then I want to use the copied sheet to run the rest of my code.
(Sheet3 is the existing sheet, S_Temp is the copied sheet)
Dim s_Temp as string
Sheet3.copy
Activesheet.name = S_Temp
Sheets("S_Temp").Range("A1").value = "Test"
How can I reference to the copied sheet?