Conditional Formatting

[Stevesmith]

Hi all,

I have a workbook with 4 sheets in it,

on sheet 1, I have a range of cells G17:X20 with a conditional format set to them, which is depending on the data set in cells G16:X16.

I have been using the following code to transfer the data from sheet 1 to sheet 3 (next available blank cell)


Sheets("SHEET 1").Range("G17:X20").Copy Destination:=Sheets("SHEET 3").Cells(65536, 6).End(xlUp).Offset(1, 0)


which works fine, until the information on sheet 1 G16:X16 changes, and then the conditional formatting which was previously set on sheet 1, on sheet 3 also changes.

What I would like is an adittion to the above code which will once the data has been copied over lock the conditional format into sheet 3 so that it does not change as sheet 1's data changes.

Any idea's please

many thanx

Steve (another day of upward learning)

[mudraker]

Please read forum rules & wrap your VBA code - see links below for rules

http://www.excelforum.com/showthread.php?t=591596

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950