• Just BeforeClose
    First , I want to calculate End Row of Col A
    Then, I am looking to write "Thank you" in every cell of COL J, till last row calculated in Col A.


  • If any row of Col A is blank, then I do not write "Thank you" in Col J of that row.


  • I want to select Range (A2:J & "End of row") excluding those rows which don't have "Thank you" in respective cell in Col J possibly using filter method, but not using Sort method.


How can I do this in VBA?