Hello,
I am still new to the vba world and still trying to figure out what will and will not work. I keep getting a "Type Mismatch" error on filez. Please Help!! And Thanks for your time!!
Please Login or Register to view this content.
Hello,
I am still new to the vba world and still trying to figure out what will and will not work. I keep getting a "Type Mismatch" error on filez. Please Help!! And Thanks for your time!!
Please Login or Register to view this content.
Hi Decoderman,
It looks like you are trying to build a string that starts with filez =.
The problem is that you try to append at the very end of this line a Range.
Ranges aren't strings. This gives a type mismatch. My best (first) guess.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
AHH I see what you mean.
new code is
Please Login or Register to view this content.
Last edited by Decoderman; 04-14-2011 at 12:38 PM.
I get the "Unable to run worksheet function" error... :-/
Now your filez is a string and it needs to be a range in the VLookup function.
Study this http://www.functionx.com/vbaexcel/Lesson03.htm
BTW - Edit your last post and put the code in Code Tags instead of Quote Tags.
Last edited by MarvinP; 04-14-2011 at 12:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks