Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
little mistery..
this works........
If aWS.Range("D27").Value = "0" And aWS.Range("P2").Value = "1" And aWS.Range("C10") = True And aWS.Range("C9") = True And aWS.Range("G9") = True And aWS.Range("G13") = True And aWS.Range("G2").Value < "0" And aWS.Range("N1").Value = "1" And aWS.Range("R12").Value aWS.Range("N2").Value Then aWS.Range("H9") = True Else aWS.Range("H9") = False End If If aWS.Range("H9") = True Then aWS.Range("H11").Value = "1" Else aWS.Range("H11").Value = "0" End If ................if i cut the H9 passage..and write directly H11 it dosn't work , not writing 1 when it's the time !!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Filtering Mistery | Excel Discussion (Misc queries) | |||
Mistery digits on excel | Excel Discussion (Misc queries) | |||
Help with emails from Excel-add via Outlook 2003 (mistery apostrophs) | Excel Programming |