Charles,

Thanks for the tips. I discovered that the F1 field was null. After I put in
checking for Nulls, the script worked great.

Thanks again for the help. Consider this closed.

--
Dave B.


"Charles Wang[MSFT]" wrote:

> Hi Dave,
> I apologize that I did not pay attention to the fact that you were using a
> script component for which debugging with breakpoints is not supported.
>
> To trace the root cause of this issue, I recommend that you use
> FireInformation (mentioned in the article "Coding and Debugging the Script
> Component") before every place you reference an object. Regarding your code
> snippet, I recommend that you use it at the following places:
> 1. Before your first If statement, check if your passed row 'Row' is null;
> 2. Check if the column F1 is null before you use it.
>
> You can also have your exception message display more information by using:
> MsgBox(ex.ToString())
>
> Hope this helps.
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>
>
>