Hi All
I have a master sheet, which has some conditional formatting in L18 down. The formula is this: =L18>$D$9+7
This is set and working fine.
In the process, we load in some data from another workbook, and put it into the master sheet with this code:
Code
'##### Clears out the unwanted data on import sheet & copies across ####
With ThisWorkbook.Sheets("Import")
.Rows("1:17").Delete
Lastrow = .Range("A" & .Rows.Count).End(xlUp).Row
.Range("L1:N" & Lastrow).Copy ThisWorkbook.Sheets("Master").Range("L18")
End With
'#######################################################################
As soon as this part of the code runs however, it somehow messes up the conditional formatting on L18 down in a weird way...
Turning it from the correct formula: =L18>$D$9+7
To: =L18>#REF!+7
I don't understand why/how its losing the "$D$9"?
There is another conditional formatting formula that is slightly different but it does the same thing, it loses the "$D$9" replacing it with the not working "#REF!"
Any idea what is going on, and how do I fix it?