PasteSpecial

[pells]

I am trying to copy the contents of cells from one workbook to another and the code below is what I have been trying to use:

Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=True, Transpose:=False
This works fine, but the formatting is copied as well as the cell contents, but I only want to copy the contents of the cells that I am copying with no formatting apart from formulas.

Does anyone know if this is possible and if so how this is done?

Many thanks for taking the time to read my post and any assistance is greatly received.

 

[Sektor]

    Paste:=xlPasteValues

 

[VoG]

Try

Selection.PasteSpecial Paste:=xlPasteFormulas

 

[pells]

    Paste:=xlPasteValues

Thanks for your suggestion - this paste's the formatting also.

Any other ideas?

 

[pells]

Try

Selection.PasteSpecial Paste:=xlPasteFormulas

Thanks for your suggestion - this paste's the formatting also.


Any other ideas?

 

[Sektor]

xlPasteValues doesn't paste formatting. Read this constant slowly.