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