currency value assigned to variable Error 2023

I have the following line in my VBA code.


billrte = Application.VLookup(startNum, Worksheets("" & sheetnm & "").Range("A2:M9999"), 16, False)

billrte is declared as a variant
startnum is set at 5
sheetnm is set to the tab name of IAAI

This exact line of code appears 8 times previous as I am assigning data to variables and it works every time, until it gets to billrte where it assigns the value of "Error 2023"

The issue appears to be that the value in the worksheet is a currency.

If I change the variable to be a currency type it throws a "Type Mismatch" error.

I have searched the forum and found nothing close to this issue.

Any help is truly appreciated.

Tim

Fast answers need clear examples.

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Try

billrte = Application.VLookup(startnum, Worksheets(sheetnm).Range("A2:M9999"), 13, False)

Please Login or Register  to view this content.

assuming required value in column M

I tested the code (as far as I am able) and it worked .....

Please Login or Register  to view this content.

No "#REF" or "#N/A" errors ?

Data in column M is Currency.

We need the file as this must a data problem.