Run-time error '1004' Unable to get the Vlookup property of the WorksheetFunction class

[lYoung]

I'm stumped. I added a new account code to my account code list. The macro runs fine until it hits the new account code "10456060" with the error Run-time error '1004' Unable to get the Vlookup property of the WorksheetFunction class. I thought the format may be different so I copied the format from the account above it and still it is getting stuck on the new code. The new code was added to the middle of the list, not the beginning or end.

This is where the macro is getting stuck and throwing the error

This is an old macro, written in June 2022 and no issues. We've had other new account codes added to the list without issue.

 

[dreid1011]

If you try that VLOOKUP manually on the worksheet, does it work with that GL code?

 

[lYoung]

What is wrong with this number "10456060"? I get #N/A. I see nothing wrong with the number.

 

[dreid1011]

What is wrong with this number "10456060"? I get #N/A. I see nothing wrong with the number.

That would suggest either the number is somehow formatted differently from the lookup cell to the lookup column, or it's not present in the lookup column.

 

[lYoung]

That took care of it. I copied the number from the original report into my account list and ran it again, it worked. Thank you!

 

[dreid1011]

You're welcome and happy to help.