VBA Using MID Function To Replace Portion Of A String

[Transformer]

UsefulGyaan Has Posted the Following On 05-30-2013 05:28 PM:

MID() Function is generally used to extract a substring from a string. The syntax of the function is: * * * * * * * * * * * * * MID(string, Start, [Length]) Here, string is the string that is being manipulated, Start is the position from which substring is to be extracted and […]





VBA Trick of the Week :: MID() Function

[snb]

In this case not the function Mid has been used but the statement Mid; homonyms for different things.
See the help files of the VBEditor.
NB. The Statement Mid does not apply to a string, but only to string variable.