Change cell value if Boolean is true

Hi,

I have the following code

Please Login or Register  to view this content.

That almost works! What I am doing is checking a tab for a list of data, if in column A it says Company then copy the entire row across as normal which is working fine, if in Column C the result is Medlay then copy this across, but change the data in cell C to different text, for example Test. From what I can see, well what the debugger tells me, is the incorrect code is

Please Login or Register  to view this content.

Can someone help please?

Hey Patel45,

Many Thanks!