Hi Guys,
I'm absolutely new to VBA and looked around for the attached code to get what i needed which does exactly what i need, it has a section to copy a range,but it doesn't keep format(it's a pivot table). I need help as to how to make it keep the format.
--Had to attach it cause i'm a new member
Attachment 26706Attachment 26707