Create a new Sheet if it doesn't exist?

Originally Posted by nbaj2k

I knwo this would be a simple IF statement. I want a new sheet within the workgroup called ChartNEW to be created if it does not already exist. I have to do this for a few different sheets, if they aren't already created to have them created.

Could someone let me know what I would put for that?

Thanks,

~J

confused, to simply create Worksheets as described something like

Please Login or Register  to view this content.

but what's 'within the workgroup' ?

---

Originally Posted by nbaj2k

Looks perfect, but how would I do it for a chart on a new sheet?

I tried Charts.Add.Name but that doesn't work.

If the Chart "Week1" was not already created I wanted it to be created.

Same thing goes for Week2, Week3.

Is it almost the same?

~J

Best thing to determine your own situation is to record a macro whilst adding a chart, last option = Chart Sheet, and copy / amend the code from there, something like

Please Login or Register  to view this content.

hth
---