Sam...I merged some coding into your coding and I'm trying to eliminate the redundancy.
Currently...
With wks
.Copy After:=Sheets("Security")
With ActiveSheet
.name = "L-" & cboYear
....... (More code)
.Range("O3") = cboYear & " YTD ROI (%):"
.Range("P1:P3") = "$0.00"
End With
.Copy After:=Sheets("L-" & cboYear)
With ActiveSheet
.name = "V-" & cboYear
....... (More Code)
.Range("O3") = cboYear & " YTD ROI (%):"
.Range("P1:P3") = "$0.00"
End With
End With
I've tried this way, but the code renames first created sheet from L-#### into V-####. The second sheet created is name L-#### (2)
With wks
.Copy After:=Sheets("Security")
With ActiveSheet
.name = "L-" & cboYear
....... (More code)
.Range("O3") = cboYear & " YTD ROI (%):"
.Range("P1:P3") = "$0.00"
End With
With ActiveSheet
.Copy After:=Sheets("Security")
.name = "V-" & cboYear
End With
End With