In part of my script I am trying to find cells with specific format, but the "format" argument of Find doesn't seem to do anything -- the method finds any cell with specified value, even though the format doesn't match. Here's my code:
Would appreciate your help!
Code: Select all
xl := ComObjActive("Excel.Application") sheet := xl.ActiveSheet xl.FindFormat.Interior.Color := 65535 ;let's say I only care about cells with yellow fill found := sheet.Cells.Find("Test", sheet.Range("A1"), -4123 , 2 , 1 , 1 , 1 , 1) MsgBox % found.Address