User defined function to create a new sheet?

[oshyguyo]

I am looking for examples of code to create a user defined function. From my understanding I can create a function myself. Then use it say in a "if" function? is that at all true?

I want to create an if statement based on a cell reference. See if we accept a project to be "approved" then i want a new work sheet to be created with the project number as it name. However I am working on one problem at a time. so have a worksheet to create based on "approved" in an "if" statement would be perfect.

Thanks again everyone!

 

[oshyguyo]

Or just a User defined function to create a new worksheet... thanks again.!

 

[pgc01]

Hi

That is not possible. A udf, like all the other worksheet functions, can just return a value, cannot insert/delete rows/columns, change the value of some cell, etc.