View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LiAD LiAD is offline
external usenet poster
 
Posts: 386
Default Paste format without borders

Hi,

I am using a PasteSpecial Paste:=xlPasteFormats code to copy cells plus
format from one sheet to another. This code copies everything.

I do not want to copy the cell border format just contents, content size,
colour, format etc plus any filling in the cells.

Is there a condition I can set so it does not copy border formats?

Thanks