I'm trying to find a cell with a specific value. I keep getting the warning:
"Can't use an undefined value as a HASH reference". Here's the code:

       my $id = $sheet->Range("A1:A$lastrow")->{'Value'};

       for my $paref (@$id){
           for my $pa (@$paref){
               print defined $pa;
               my $found = $sheet2->UsedRange->Find({What=>"$pa"})->{Row};
               print "search:$pa\n";
               print "found:$found\n";
           }
       }

The first print shows the variable is defined.
If I comment out the "found" lines, the second print does print the value.

Reply via email to