I am trying to trap an error where the Value of hcpc(i) is not found on the data sheet. Partial code is below.
I tried this:![]()
Set rngFound = lookupsht.Range("A1:H1257").Find(hcpc(i), , , xlWhole) ruv(i) = rngFound.Offset(, 1).Value
![]()
Set rngFound = lookupsht.Range("A1:H1257").Find(hcpc(i), , , xlWhole) If ruv(i) = rngFound.Offset(, 1).Value Is Empty Then feevalue(i) = 0 descrip(i) = "Unidentifiable Charge" reason(i) = "HCPC Code Not Found in Fee Schedule" Else ruv(i) = rngFound.Offset(, 1).Value
Bookmarks