Hi,

I am working with the following part of code;

Machs = Array("Mach-1", "Mach-2", "Mach-3", "Mach-4", "Mach-5", "Mach-6", "Mach-7", _
         "Mach-8", "Mach-9", "Mach-10", "Mach-11", "Mach-12")

For Each Mach In Machs
    If Range("O236") > 0 Then
    Worksheets.Add(After:=Worksheets(1)).Name = "My New Worksheet"
Next Mach

What would i replace "My New Worksheet" with to get the current worksheet name (see array above) plus the word "Budget"?


Thanks