-1
I have code, that is identical minus two changes that would happen each time, which I can use variable for, but I dont want to use a bunch of if statements.
the code I have is
C = 1
fnd = Sheet1.Cells(C, 8)
While InStr(fnd, "Customer Name:") <= 0 And C <= 300
C = C + 1
fnd = Sheet1.Cells(C, 8)
...