So I'm working with VBA to copy and past pivot talbes into a new worksheet. I have several different pivot tables that are being pasted into the new worksheet, one of which has some ranges 0-4, 5-9,10-14 and 15+. When it pastes 5-9 and 10-14, it keeps coming up as May 9 and October 14, how do I fix this? I've reformatted the cells each time but it still either comes up with that date or the code for that date but not the range. Yet the pivot table has the proper ranges with no problems. Please help....
