Simple VBA programming in Excel

[wagee]

I am trying to write a simple VBA program for a spreadsheet. However I
am stuck. I am learning this as I go along so that is the big problem
no doubt. I need to copy a sheet and rename. Simple eh? I copy it no
problem but cannot figure how to change the copyed name (now
firstname(2) for instance) to a new name. A cut out of the utility is
below:

Private Sub copysht()
sname = "dog"
Sheets("Template").Copy after:=Worksheets(Worksheets.Count) '.name
= "sname" 'copy at the end
Sheets("Template(2)").name = "sname"
'ActiveWorkbook.Sheets("Template(2)").name = "sname" 'give sheet a new
name but it blows up on Template(2)!
End Sub

 

[md]

You would have a better chance of getting an answer if you post to a
newsgroup on VBA or Excel. This is a .Net programming group.

 

[wagee]

You would have a better chance of getting an answer if you post to a
newsgroup on VBA or Excel. This is a .Net programming group.







- Show quoted text -

Thanks for the pointing that I hopefully I found one.

Wayne