10-15-2014, 02:09 AM
lionking Wrote:Where is your value locate at? I mean in what cell?
Could you give an example that you have the value that match "apple" and "X" so that I could have a clear picture of what are you talking about?
I'm sorry, not know English.
For example :
Quote: ExcelSheet KeyFind.Init("")↑Source Code↑"apple" text find
KeyFind.Activate
ARRAY(Excel.Range) KF
if(!KeyFind.Find("apple" KF)) out "not found."
out KF[0].Value; out KF[0].Column; out KF[0].Row
KeyFind.ws.Application.Goto(KF[0])
wait 1
KeyFind.GetRangeInfo("<sel>" 0 row)
KeyFind.SelectCell(2 row)
out KeyFind
But, I want Values that match two conditions
For example :
"apple" and "O" = Do not search
"Pineapple" and "O" = Do not search
"apple" and "X" = True(search and A1224 Cell move)
I'm sorry. I don't speak English well.
