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