finding circular references

1. If you can't find the error, click the Formulas tab, click the arrow next to Error Checking, point to Circular References, and then click the first cell listed in the submenu.
2. Review the formula in the cell.

how to work with the visible rows after applying autofilter

    ActiveSheet.Range("$A$1:$J$5").AutoFilter Field:=2, Criteria1:="3"
    Range("A2:A" & Cells(Rows.Count, "A").End(xlUp).Row).SpecialCells(xlCellTypeVisible).Copy _
        Sheets("Email").Range("A30")

vlookup not working on cell with formula

even if a cell (the referencing cell) is formatted as general, if the formula within refers to another cell that is formatted as text, vlookup treats the referencing cell as text.