Paul Rousseau sent the following code:
$row = $Sheet->UsedRange->Find ({What => "ParentItemName",
SearchDirection => xlNext, SearchOrder => xlByRows}) -> {Row};
I've never worked with Perl-Excel, so this is something of a SWAG,
but...could you wrap the assignment in an eval block and then test $@ for
failure?
HTH
Deane Rothenmaier
Programmer/Analyst
Walgreens Corp.
847-914-5150
A word to the wise ain't necessary, it's the stupid ones who need the
advice. -- Bill Cosby
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs