Hi All,
anyone could help me to write a Macro for:

In Colomn A, From A12 to A?? I have Text.
The last Cell in Colomn A is variable, (is A50 now but tom, can be
A500)

I want a Macro that does:
In Cell E12, the Formula :
E12 = If(And(B12="",C12="",D12<""),D12)
and copy the formula to Cell E...(last Value in Colomn A).
E13 = if(and(B13="",C13="",D13<""),D13)
....
....
Exx = if(and(Bxx="",Cxx="",Dxx<""),Dxx)

Regards
Herve


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=547758