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.