I would appreciate any assistance to the following VBA that I'm trying to use. Currently I'm getting a runtime error 1004
Please Login or Register to view this content.
I believe the VBA works fine up until the THEN, I think the error is after THEN
Thank you
Last edited by alansidman; 11-16-2017 at 02:24 PM. Reason: code tags added
Ifna is a worksheet formula and not a VBA formula. If you want to use Ifna in VBA then you will have to preface it with Application.WorksheetFunction. This is also true for the vlookup function.
Look at this link to ensure an understanding.
http://www.ozgrid.com/Excel/free-tra...a1lesson18.htm
http://www.cpearson.com/excel/callin...ionsinvba.aspx
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi tdf,
You have:
I have a problem with the period between $A$1.$B$10000Please Login or Register to view this content.
I also have a problem with this VLookup as your data is only 2 columns and you want column 3 returned.
See if that helps first...
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
In addition to the period/colon issue that Marvin noted, I also noticed that the number of quote marks is wrongPlease Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
MarvinP, thanks for checking my errors, I should have seen those before posting. However, with the corrections made, I'm still getting a runtime error message. I will have to check further into what Alansidman is postingOriginally Posted by MarvinP
Hi tdf,
You have:
I have a problem with the period between $A$1.$B$10000Please Login or Register to view this content.
I also have a problem with this VLookup as your data is only 2 columns and you want column 3 returned.
See if that helps first...
thank you for the suggestion, but I'm still getting a runtime error with this correctionIn addition to the period/colon issue that Marvin noted, I also noticed that the number of quote marks is wrongPlease Login or Register to view this content.
So now we assume you ware working with
right?Please Login or Register to view this content.
And you have both tabs named correctly as test and pivot1?
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
thank you. And thanks to all who took the time to read and helpSo now we assume you ware working with
right?Please Login or Register to view this content.
And you have both tabs named correctly as test and pivot1?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks