Public Sub RAnalysisProject()
Dim Owner$, Référence$, Mitigation_Plan$
Application.ScreenUpdating = False
'Application.CutCopyMode = False
Référence$ = Sheets("Parameters").Range("Default_Ana").Value & "P_" & Format(Now(), "ddmmyyyyhhmmss")
Sheets("Risks weighted analysis Proj").Select
Sheets("Risks weighted analysis Proj").Copy Before:=Sheets(1)
Sheets("Risks weighted analysis Pro (2)").Select
Sheets("Risks weighted analysis Pro (2)").Name = Référence$
For i = Sheets.Count To 1 Step -1
X = Sheets.Item(i).Range("E5").Value
A = Sheets.Item(i).Name