I'm trying to write a custom function that makes use of a temporary worksheet. To add a sheet in a regular sub procedure "Sheets.Add.Name = Temp" seems to work just fine. However, this doesn't work in my function. Is there another way to add a sheet while in a function? or is this something that functions inherently can't do? or am I just missing something completely?

Thanks much.