My fault, I forgot to double the double quotes within the string. (I was
editing your formula).

ActiveCell.Offset(0, 4) = "=IF(" & _
ActiveCell.Offset(0, 5).Address(0, 0) & _
"<=$L$3,""Y"",""N"")"

--
Regards,
Tom Ogilvy


"humet" wrote in message
...
Thanks again for the extremely fast reply.

But, when I enter this line of code:

ActiveCell.Offset(0, 4) = "=IF(" & ActiveCell.offset(0,5).Address(0,0)
& _
"<=$L$3,"Y","N")

I get a compile error: expected: End of statement. It highlights the
Y.

Can this be fixed?

Thanks in advance,

humet


---
Message posted from http://www.ExcelForum.com/