Hi all,
I have a vlookup function (VBA) used to find an email address in excel which is then used to automatically populate the to field in an email.
This has worked fine all year but i have had to add a few more contacts recently, now for some reason i can't fathom i'm getting the 'Run-time error 1004 - Unable to get the VLookup property of the worksheet function class'. Interestingly the formula/range is the same for the 'To' (emailcil) and 'CC' (emailscc) email addresses and the error only comes up for the 'CC' Lookup.
So to clarify a bit the code bugs out on the emailscc line but the emailcil line is fine. I've checked the value in the variable 'Projup', it is correct and can be found in column A where the cells are formatted as 'General'.
Hope someone can help or advise on a workaround!
Thanks
Dan
Bookmarks