Hi All,
I am trying to create a Vlookup below:
Sheet9.Range("B2").Value = Application.VLookup(Me.cboEngineer, Sheet7.Range("Engineers_Full"), 8, False)
For some reason it's not working and I get the error "Error 1004 (Method 'Range@ of object '_Worksheet' failed) in procedure cmdReady_Click"
Could anyone please assist, i'm unsure as to why it's not working.
Any help appreciated!
Many Thanks,
Froob!
Can't tell by just looking at this one line of code (also please read our rules, we request code tags to preserve code formatting but don't bother for one line of code). My first guess would be that there is no named range Engineers_Full in Sheet7. Check the spelling of the name and make sure it is defined in Sheet7.
If that doesn't help, the next step would be to attach your file. If you have private data you can remove the data first, I would just want to see the structure of the file and all of the code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks