Creating a new worksheet

[amiersen]

What's the easiest way to create a new worksheet in an "IF" statement?

 

[Cbrine]

Not sure exactly what you are looking for, but here's some code for adding a worksheet

If activesheet.range("A1").value ="Yes" then
    ActiveWorkbook.Worksheets.Add
End IF

HTH
Cal