Of course - do you have criteria for creating a new sheet?

Dim myS As Worksheet

If Criteria = True Then
Set myS = Worksheets.Add
myS.Name = "Newly added sheet"
End If

Then you can either use

myS.Cells(row, col).Value = "Whatever"

or

Worksheets("Newly added sheet").Cells(row, col).Value = "Whatever"


HTH,
Bernie
MS Excel MVP


"Isis" wrote in message
...
"Bernie Deitrick" <deitbe @ consumer dot org wrote in
:


Bernie,

Sorry for not replying sooner - yes, that code demonstrates what I needed
to know - thank you very much.

Is there a way to check for (and create if needed) a new sheet ?

Thanks