conditional match function
Hi All
i'm using the following which works well:
m = Application.WorksheetFunction.Match(UCase(contname ),
Range("Container_Number"), 0)
and returns the line number of the row where contname is found in the range.
However, i now only want to return the row number where column A in that row
is blank e.g.
A B
1 Ref Container Number
2 AAA_001 AAA
3 AAA_002 AAA
4 AAA
so i want row 4 not row 2
what's the easiest way to do this?
Cheers
JulieD
|