Hi, i'm new here. I'm trying to copy data from a cell without borders and formula, just paste value and blank
I know Paste:=xlAllExceptBorders option, but this option include cell's format.
I try this:
But it didn't work![]()
With Range("A2") .PasteSpecial xlAllExceptBorders .PasteSpecial xlPasteValues End With
Any help would be appreciated. Thanks.
Bookmarks