below code highlights the rows where the value in Column 'C' (item codes) starts with the string '03-'.
The item codes starting with the string '03-' are located in just one column but they may be in a different column in another data list.
So could somebody please help me rewrite this code so that ...
... the macro searches for the first occurrence of the string '03-' in the data list and sets that column as a variable replacing the hard coded "C" in line 4
Help is much appreciated.
Thank you very much in advance.
Dim row As Range
For Each row In ActiveSheet.UsedRange.Rows
If InStr(1, row.Cells(1, "C"), "03-") Then
row.Interior.ColorIndex = 6