Run-time error '7': Out of memory

Hi,

I apologize for the large post but I included the code and the body of problematic text so you can recreate the problem. I am at a loss at why I am not allowed to write a large chunk of text (see below) to a cell. I have isolated it to this statement: vOutputWS.Cells(vCurrentRow, vOutputCurrentColumn).Value = vTextLeft

I am manually parsing a tilde (~) delimited row into separate cells. When it hits this chunk of text which is assigned to the variable "vTextLeft" it consistently displays a dialog with the message in the Title.

The data source that pulls the initial tilde delimited data is coming from Oracle via ODBC in Excel. The next step is to parse the data into cells.

Any suggestions?

Excel 2000 on Windows 2000 Professional

Large chunck of text:

-Quickly fill out your basic childcare information on the top left side of the form. It is your responsibility to give the monthly sign in sheet to your childcare provider. Keep this form at your provider's site in a place where it will be easy for you to sign your name. You must sign your child in and out on the sign in sheet each day. You must verify, with your signature, the time in and out for each child every day. This monthly sign in sheet will be your record of the total hours of childcare provided during the month. It is important that the childcare sign in sheet is filled in every day you use childcare. It is your responsibility to sign your children in and out every day. At the end of the month, you and the childcare provider need to sign your names at the bottom of the monthly childcare sign in sheet.



-At the end of each month, the other form that you need to complete is the CW child care eligibility report. You complete section 1 on the front of the form and sign your name (initials cannot be used). Your childcare provider completes section 2 on the back of the form. The information gathered allows the county to confirm that our records have current and correct childcare information on file. Then you and the childcare provider sign your name at the bottom of the form.



-After both of these forms are completed, it is your responsibility to submit them to your childcare worker by the 5th day of the next month. Here is why: the faster the forms are submitted, the quicker your childcare provider will receive their payment. This is very important - otherwise they will not accept your child into care. So, it is really important that both these forms are submitted on time, in a complete way, with correct information. When forms are not filled out completely, have incorrect information, missing signatures or are turned in late, it will affect your childcare provider's payment. Help us out by submitting the forms by the 5th of the month. It will make life easier for you, your children, your provider and the staff at DSS.



You will receive step-by-step instructions with each of the forms. These instructions will provide you with the information you need to complete the forms correctly.

Google your error message to see if that helps.

For example:
http://support.microsoft.com/default...;en-us;Q257947
and
http://support.microsoft.com/default...;en-us;Q173182
and there are probably other strange issues.


--
My handle should tell you enough about me. I am not an MVP, expert, guru,
etc. but I do like to help.


"rpollard001" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> I apologize for the large post but I included the code and the body of
> problematic text so you can recreate the problem. I am at a loss at
> why I am not allowed to write a large chunk of text (see below) to a
> cell. I have isolated it to this statement:
> vOutputWS.Cells(vCurrentRow, vOutputCurrentColumn).Value = vTextLeft
>
> I am manually parsing a tilde (~) delimited row into separate cells.
> When it hits this chunk of text which is assigned to the variable
> "vTextLeft" it consistently displays a dialog with the message in the
> Title.
>
> The data source that pulls the initial tilde delimited data is coming
> from Oracle via ODBC in Excel. The next step is to parse the data into
> cells.
>
> Any suggestions?
>
> Excel 2000 on Windows 2000 Professional
>
> Large chunck of text:
>
> -Quickly fill out your basic childcare information on the top left side
> of the form. It is your responsibility to give the monthly sign in
> sheet to your childcare provider. Keep this form at your provider's
> site in a place where it will be easy for you to sign your name. You
> must sign your child in and out on the sign in sheet each day. You
> must verify, with your signature, the time in and out for each child
> every day. This monthly sign in sheet will be your record of the total
> hours of childcare provided during the month. It is important that the
> childcare sign in sheet is filled in every day you use childcare. It
> is your responsibility to sign your children in and out every day. At
> the end of the month, you and the childcare provider need to sign your
> names at the bottom of the monthly childcare sign in sheet.
>
>
>
> -At the end of each month, the other form that you need to complete is
> the CW child care eligibility report. You complete section 1 on the
> front of the form and sign your name (initials cannot be used). Your
> childcare provider completes section 2 on the back of the form. The
> information gathered allows the county to confirm that our records have
> current and correct childcare information on file. Then you and the
> childcare provider sign your name at the bottom of the form.
>
>
>
> -After both of these forms are completed, it is your responsibility to
> submit them to your childcare worker by the 5th day of the next month.
> Here is why: the faster the forms are submitted, the quicker your
> childcare provider will receive their payment. This is very important
> - otherwise they will not accept your child into care. So, it is
> really important that both these forms are submitted on time, in a
> complete way, with correct information. When forms are not filled out
> completely, have incorrect information, missing signatures or are
> turned in late, it will affect your childcare provider's payment. Help
> us out by submitting the forms by the 5th of the month. It will make
> life easier for you, your children, your provider and the staff at
> DSS.
>
>
>
> You will receive step-by-step instructions with each of the forms.
> These instructions will provide you with the information you need to
> complete the forms correctly.
>
>
> --
> rpollard001
> ------------------------------------------------------------------------
> rpollard001's Profile:
> http://www.excelforum.com/member.php...o&userid=31439
> View this thread: http://www.excelforum.com/showthread...hreadid=511295
>