Hi Guys,

I think I'm having a "thick" day!
Part of my code copies a range from one sheet and pastes into another. I want to retain the number formats in the destination sheet but not the borders or conditional formats from the source sheet.
I could have sworn that it wasn't that difficult to opt out of certain formats, but I can't figure it out.

The section of code is very basic:-
stock.Range("A1:n" & LR).Copy
searchsheet.Range("A1").PasteSpecial
Can someone put me out of my misery... not literally, I hasten to add!

Thanks
Chris