Hi, im trying to add a new sheet to a workbook at the moment im using this
which fine but how can i make the new sheet be called "results"
i was using this method bellow but i heard its not best practice
cheers
Code:
Dim WS As Worksheet
Set WS = Sheets.Add
i was using this method bellow but i heard its not best practice
Code:
[FONT=Arial][SIZE=2]Sheets.Add.Name = "results"[/SIZE][/FONT]