Carrying formulas into other sheets

[dbondmelo]

Hi Everyone,
Looking for some help here. I have this formula that looks at a column and creates a new sheet based on the persons name in column D.. Works great but once that is not working is in my master SHEET (before it's copied) I have a formula and that formula does not carry over into the other sheets.

Any ideas?

thanks
Dereck

Please Login or Register  to view this content.

[dbondmelo]

Just ran this in STEP into mode and noticed something. If I get to the part of the code below. The first sheet that's created has the formula still. But the second, third and 4th loose the formula.

I'm assuming it's part of the RANGE.COPY SHEETS(RNG.TEXT) part.. but I have no idea what to change it to.

Please Login or Register  to view this content.