Subscript out of range error

[Nelly2015]

Dont know what went wrong.

Sub AutoFormula2020()
Dim i As Long
ActiveWorkbook.Sheets("Overall").Cells(2, 2).Select
For i = 2 To 14 Step 1
Cells(2, i).Value = Cells(2, i).Value * -1
Cells(3, i).Value = Cells(3, i).Value * -1
Next i

End Sub

 

[Zot]

I didn't say that they were, I said it was something to consider. The cells could have been locked manually at some point, there was no indication either way in your post.

Maybe there was a stray space at the beginning / end of the name. That is enough to make the code think that the sheet doesn't exist.

Yes. Space plays trick and sometimes Overall and Overal look similar ?. That is why some like to put Trim command.