problem highlighting row

You are modifying the text file in your subsequent code and when you run the avertMain routine before the modification code, none of your rows actually have MAIN in column A and FFR0 in column D. So, you just need to change the order the macros are called in in the tst sub:

  Call Module3.SuppLignes
  Call Module2.tableau
  Call Module2.avertMain