Hi

Hope you can help.

I am wondering is there a quicker way to use a For loop as below, maybe a For Each? I am not that good with looping and your advice would be greatly appreciated.
I use a for loop as each row in the sheet is assessed with a condition but this is a double check that not every row would contain a NOT AVAILABLE.

For Index = 2 To LastRow
            Range("Y" & Index).Select
            
                            
                    If ActiveCell = "Not Available" Then
                            ActiveCell.FormulaR1C1 = "FORMULA"
                            
                        
                    End If
                    
        Next Index