"find" method malfunction when filter is applied

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)

Find(What:="*", LookIn:=xlValues, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

finds the last row in sheet, not column E only, i.e. whatever column has the lowest(Longest) data.

If you want to find the last row in column E, you should use

Lastrow= Range("E"&rows.count).end(xlup).row

As you can see, I begin with "ThisWorkbook.Worksheets(idx1).Range("E4:E3003"). " which limits the search only to column E.
Try end(xlup) and you will see, that it also does not work, when some rows are filtered (= not displayed).
Furthermore, end(xlup) will not ignore blank cells containing formulas (= no values, just formulas).
But thanks.

This dynamic range evaluation should speed up data processing by limiting calculation only to relevant rows. There are thousands of rows on several worksheets.

There is no error, just evaluation of the last non-blank E-cell is incorrect, when filtering is applied (which I verified using "add watch" while debugging). I'm just trying to set dynamic range depending on the last non-blank E-cell... for further processing of data in other columns on several worksheets across workbook...

Lastrow=Find(What:="*", LookIn:=xlValues, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

Finds the last row in all columns(All columns in a sheet)

Lastrow= Range("E"&rows.count).end(xlup).row

Finds the last row in a single column "E" ONLY