When you add a worksheet, it becomes the active worksheet. So, at that point, c2.Value will have nothing in it because it relates to the currently active sheet, the one you just created. Try fully qualifying c2.Value with the original sheet name.

Regards, TMS