How to fetch the entire row in excel which is highlighted

[spoo]

 

Hello guys,

How to get the row which is highlighted in yellow color.

that is row 44 and 49

 

Thanks in advance

 

[Nine]

Do you want to read the rows 44 and 49, or do you want to read the rows that are highlighted (whichever rows it could be) ?

[water]

If you are looking for yellow cells then the answer is: No, the UDF does not support the needed FindFormat function.
I check if you can filter on color and then just read the filtered lines.

Another way is to use COM without the UDF as described here:
https://docs.microsoft.com/en-us/office/vba/api/excel.cellformat

[water]

This example works for me (for red cells):

#include <Excel.au3>

; Create workbook with 3 rows and 3 columns. Set cells A1 and A3 to red
Global $aUsedRow, $sMaxUsedColumn
Global $oExcel = _Excel_Open()
Global $oWorkbook = _Excel_BookNew($oExcel)
Global $aValues = [[11, 21, 31], [12, 22, 32], [13, 23, 33]]
_Excel_RangeWrite($oWorkbook, 1, $aValues)
Global $iRed = 234 ; Hex 0xEA
$oWorkbook.Activesheet.Range("A1").Interior.Color = $iRed
$oWorkbook.Activesheet.Range("A3").Interior.Color = $iRed

; Get the max used range of the active sheet
$sMaxUsedColumn = _Excel_ColumnToLetter($oWorkbook.ActiveSheet.Usedrange.Columns.Count)
; Loop through all rows and check column A for a red cell. If found, read all used cells of this row and display the array.
For $i = 1 To $oWorkbook.ActiveSheet.Usedrange.Rows.Count
    If $oWorkbook.Activesheet.Range("A" & $i).Interior.Color = $iRed Then
        $aUsedRow = _Excel_RangeRead($oWorkbook, $oWorkbook.Activesheet, $oWorkbook.Activesheet.Range("A" & $i & ":" & $sMaxUsedColumn & $i))
        _ArrayDisplay($ausedRow)
    EndIf
Next

[spoo]

@Nine

 

I want to read rows which are highlighted .

[spoo]

@water

Thanks for the reply,

I will try  and let you know if that worked

 

Edited May 2, 2019 by spoo