I am trying to fill in a column through a macro in excel and I am using the following code. Everytime I try to use it I get a syntax error or a compile error and the whole line with my formula gets red, I think that it has something to do with my "" marks within the formula. Any idea how I could correct that ? Thanks in advance to anyone
Sub Status()
Dim LastRowColumnA As Long
LastRowColumnA = Cells(Rows.Count, 1).End(xlUp).Row
Range("AU4:AU" & LastRowColumnA).Formula = "=IFS(AL4=1;"open";AL4=2;"closed";AM4=1;"open";AM4=2;"closed";AK4=1;"open";AK4=2;"closed";AK4=4;"not-submitted")"
End Sub
Aucun commentaire:
Enregistrer un commentaire