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.