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 […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=833&subd=usefulgyaan&ref=&feed=1





VBA Trick of the Week :: MID() Function (http://usefulgyaan.wordpress.com/2013/05/30/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.