I want to look in all the strings of an array for a substring that has the value of my variable 'Get' in it. Then, I want to add "SB =" and the value of variable SBValue (As Long) to the end of the string in each array element that contains the value of "Get". Eventually all elements of FineArr get "joined" and used in a text file.
All variables and arrays are declared, I think I just don't have the right syntax, or the right idea?
For I = LBound(FineArr) To UBound(FineArr)
If Instr(FineArr(I), Get) Then Tmp2 = FineArr(I), "SB =", SBValue
FineArr(I) = Tmp2
Next I
I'm sure there is a better way to add the necessary to each array element without using a temporary string?