Hi, I am trying to put this formula " ="*"&MID(B7,SEARCH("(",B7)+1,SEARCH(")",B7)-SEARCH("(",B7)-1)&"*" " in a range of cell from row 7 to lastrow(Column E) using VBA code. but cannot figure out how to do that using VBA because concatenate is involved.
The above code needs to be changed such that the range will be updated with the formula mentioned above. TIA
Code:
For k = 7 To lnglastrow
Range("G" & k).Formula ="=MID(B7,SEARCH("(",B7)+1,SEARCH(")",B7)-SEARCH("(",B7)-1)"
next k
The above code needs to be changed such that the range will be updated with the formula mentioned above. TIA