SRMPURCHASE
Board Regular
- Joined
- Dec 23, 2014
- Messages
- 210
- Office Version
- 2016
- Platform
- Windows
I use the VBA script below to copy a row of data, insert a blank row above and paste the copied data in the blank row. I then edit the date of the pasted data along with any other changes to the data from the copied data.
My question is, every time I invoke this VBA the range of the newly pasted data is added to the conditional formatting range.
Is there a way to keep the CF as set without adding the new range to the CF formula bar?
Sub COPYROWINFOUP()
With Selection.EntireRow
.Copy
.Insert
End With
Application.CutCopyMode = False
End Sub
My question is, every time I invoke this VBA the range of the newly pasted data is added to the conditional formatting range.
Is there a way to keep the CF as set without adding the new range to the CF formula bar?
Sub COPYROWINFOUP()
With Selection.EntireRow
.Copy
.Insert
End With
Application.CutCopyMode = False
End Sub