macro help

[MIAGIRL57]

I need coding such that if both of 2 cells (I335 & L335) are blank then some text "??????" will be put in another cell, but if this expression proves false I need the data in that cell (M335) to be left alone…
a formula can do this, i.e., =IF(AND(I335>0,L335>0),"????????????",M335)
but then of course no formula is in the cell, M335 for future use, reference, etc. So I wondered how you would do this with a macro? Any suggestions?

 

[Smitty]

Welcome to the Board!

Something like this maybe:

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> foo()<br>    <SPAN style="color:#00007F">If</SPAN> LenB(Range("I335").Value) = 0 And LenB(Range("L335").Value) = 0 <SPAN style="color:#00007F">Then</SPAN><br>        Range("E335").Value = "?????"<br>    <SPAN style="color:#00007F">Else</SPAN><br>        Range("E335").Value = Range("M335").Value<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

HTH,