I have some vba code that contains exact information that needs to be flexible. I've included a portion of code with a cell value below, but some vba references a file name or drive information with the year 2016.
For i = 2 To lastRow
If Cells(i, 8).Value = "2016" Then
Cells(i, 1).Resize(1, 20).Interior.ColorIndex = 36
End If
Next i
I would like to be able to change a specific word/number without manually accessing module and find/replacing all 2016.
Is there another option?
Bookmarks