"find" method malfunction when filter is applied

Hello,

This code:

Please Login or Register  to view this content.

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)

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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.

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...

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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