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.
