Hi, I never tried this in real life... but I am pretty sure that the "line wrap" in the Excel cell is interpreted as a control character like 0Dx and/or 0Ax. So the "compare" value of your function should be a concatenation of "My line" ยจ+ cr/lf + "Line 2"
to put in this way, if you know Basic: wrapperchar$=chr$(10) cellvalue$ = "My line" & wrapperchar$ & "Line 2" ...while I am still not sure what Excel gives you back as the line wrapper in the text. This means the "wrapperchar" could be chr$(13) or even chr$(13) & chr$(10) I hope you get the picture... sorry I can't give you a working example, am somehow offlined here. Thomas_______________________________________________ WebTest mailing list [email protected] http://lists.canoo.com/mailman/listinfo/webtest
