none
I need to find data I a column not the formula RRS feed

  • Question

  •  I have a range “AJ15:AJ42” all the cells in this range have excel formulas that looks like this “=IF(SUM(S24:AI24)=0,"",SUM(S24:AI24))” what I need is to fine the last row in column “AJ” that have a value of the sum not the formula.

    I though this will work but isn’t

    lastrow = wksws.Range("AJ42").Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows, LookIn:=xlValues).Row


    Vforum

    Sunday, November 3, 2019 3:14 PM

Answers

  • Use

    lastrow = wksws.Range("AJ15:AJ42").Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows, LookIn:=xlValues).Row


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Kosta si Sunday, November 3, 2019 3:50 PM
    Sunday, November 3, 2019 3:45 PM

All replies

  • Use

    lastrow = wksws.Range("AJ15:AJ42").Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows, LookIn:=xlValues).Row


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Kosta si Sunday, November 3, 2019 3:50 PM
    Sunday, November 3, 2019 3:45 PM
  • thank you worked

    Kosta


    Vforum

    Sunday, November 3, 2019 3:50 PM