Hello Everyone,

What is the VBA equivalent to LEFT(A1,3) which we use in formulas so that I
can do the following:

I am trying to write some code in VBA that will kind of parse a form and
format it on a copied book. That part is all done. Then I want to insert
rows with dates that are not parsed from my document. Example.. my parsed
form looks like this:

09/04/04 text
09/05/04 text
09/06/04 text

I want to make it so that the dates from the 1st to the 4th, are created
before the ones above to look like this:

09/01/04 OFF
09/02/04 OFF
09/03/04 OFF
09/04/04 text
09/05/04 text
09/06/04 text