I'm having in issue with the code below. I believe the issue is the name of the worksheet and how it's listed in the code. The worksheet that the dynamic range "Lookup" is in is called "CLIENTS"....but if I put that name as shown below i get a 424 error. If i rename the worksheet to Sheet1 and change the name in the code to match, I dont get the error but the vlookup doesn't work.
Please Login or Register to view this content.
Bookmarks