Hello,

This code:

    LastCellE = ThisWorkbook.Worksheets(idx1).Range("E4:E3003"). _
               Find(What:="*", LookIn:=xlValues, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
works well until filter is applied to column E (which results in hiding some rows...). Then it works incorrectly. The code simply finds the last row with non-empty cell in column E.

Any suggestion? Thanks.

(E-column cells contain matrix formula)