vba fill down conditional formatting to last row with data in a table

[willow1985]

Hello,

I have a macro for a spreadsheet that updates from one Sheet to another report with a table. It updates only 1 row at a time (which is all that is required) and I was wondering how can I copy down the conditional formatting once the information is pasted? The below code copies the information from Range A2:J2 from the "New NCR" Sheet goes to Sheet NCR Log, finds the first blank cell in Column A and pastes special values.

Sheets("New NCR").Select
Range("A2:J2").Select
Selection.Copy
Sheets("NCR Log").Select
Range("NCRLog").Cells(1, 1).End(xlDown).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

After this I would like to bring down the conditional formatting from the row above column: A:J then continue with the rest of my code.

Any help would be most appreciated.

Thank you!

Carla

 

[willow1985]

The table seems to be automatically copying down the conditional formatting now....strange. Well so far it is working without manually having to copy it down. Hope it continues to do so.