Private Sub Worksheet_Activate()
With Feuil1.UsedRange 'CodeName de la feuille à adapter
With .Columns(2) 'colonne auxiliaire
.FormulaR1C1 = "=Mots_Gras(RC[-1])"
.Value = .Value 'supprime les formules
.Cells(1) = "MOTS GRAS"
[A1].Resize(.Rows.Count) = .Value 'copie les valeurs
[A1].Offset(.Rows.Count).Resize(Rows.Count - .Rows.Count).ClearContents 'RAZ en dessous
.ClearContents 'RAZ
End With
End With
Columns(1).AutoFit 'ajustement largeur
End Sub