Copy Paste Formulas

[MrGJEB]

Hi,

Is it possible to use VB code to copy a row and paste only the formulas and cell formats to the next row. I dont want the values to be pasted.

Many Thanks

Grant

 

[Jon von der Heyden]

Hi Grant

using VBA, the following is an example:

Sub example()
With ActiveCell
    .Copy
    .PasteSpecial xlFormulas
    .PasteSpecial xlFormats
End With
End Sub

Assumes you want to copy formula and ALL formats...

 

[MrGJEB]

This copies the formula and formats but also the values. I do not want to copy the values of the cells.

Any help

 

[Jon von der Heyden]

Do you mean:

1. If the cell has a formula then copy the cell and paste formula and cell formats?
2. If the cell has a constant then copy the cell and paste only formats?

 

[MrGJEB]

i have found it.

after your code i have inserted the line:

Selection.cells.specialcells(xlcelltypeconstants).clearcontents

It seems to be working now.

Thanks for your help