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

Reply via email to