Excel assign copied sheet name as variable

Question

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?

user362729 · Accepted Answer · 2010-06-09 19:05:42Z

2

Here's the solution I've just found:

Dim s_Temp as Worksheet
Sheet3.copy   
set S_Temp  = Activesheet  
S_Temp.Range("A1").value = "Test"

answered Jun 9, 2010 at 19:05

user362729

1131 gold badge3 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

shahkalpesh · Accepted Answer · 2010-06-09 18:59:39Z

1

Sheet3.copy 
'From this point onwards, the active sheet has changed
Activesheet.name = S_Temp

'Hence, this will be A1 on the copied sheet.
Range("A1").value = "Test"

Have I misunderstood the question?

answered Jun 9, 2010 at 18:59

shahkalpesh

33.6k4 gold badges66 silver badges89 bronze badges

2 Comments

user362729 Over a year ago

Thanks shahkalpesh, I've found my mistake, see my answer

user362729 Over a year ago

That's partially what I wanted to do. The problem was when you first copy sheet3 it becomes by default your activesheet. Then I select another sheet's data to paste in my copied sheet3. I didn't how to reference the copied sheet since its name is created by excel randomly.

Collectives™ on Stack Overflow

Excel assign copied sheet name as variable

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related