Can this formula be converted to a vba macro? If so, how??
This formula is copied down 35000 rows in column K of my worksheet
=IF(AND(IF(20030905=G2,IF(20030905<=H2,IF(MID(I2, 5,1)="Y",1,0),0),0)=1,
IF(OR(A2="DTW",A2="MEM",A2="MSP",C2="DTW",C2="MEM" ,C2="MSP"),IF(E2="CO",
0,1),IF(E2="NW",0,1))=1),1,0)
Thanks.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!