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?
I would normally create a "configuration" or "control" sheet and store that kind of variable information there. I usually define Named Ranges so that the structure of the configuration sheet is also flexible. Then you never touch the code.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks