Row insert copies down cell shading. Can this be avoided? Copying formulas preferred though.

[BobZZ]

When I insert a row in VBA the default behaviour of excel is to copy the cell shading from the row above it. I would like to stop this from happening. It would be nice though if it copied the cell formulas from below it though.

 

[JackDanIce]

Welcome to the board. You need to use pastespecial, e.g.

Range("A2").EntireRow.Insert
Range("A1").Copy
Range("A2").PasteSpecial Paste:=xlPasteFormulas

Quick internet search: http://www.mrexcel.com/forum/excel-questions/411816-pastespecial-formulas.html