424 Error
All
So I am using a lookup table to calculate a date and Iam getting stuck on a 424 error. I am pretty sure I dim'd the hold values at the start no dice. I have tried to remove the holding numbers but again no play...
Please Login or Register to view this content.
A quick Google suggests you should check for misspellings.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Also, if you click on debug when you get the error, Excel should highlight the line of code where the error is occurring.
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
I will give that a shot spelling is not my strong point.
@alan I did that. I have commented the dodgy line.
If this is the problem line you should split out the Application.Match parts to make things easier to debug.
For example.Please Login or Register to view this content.
Please Login or Register to view this content.
If posting code please use code tags, see here.
@Norie yeah that seemed to work. Now trying to work out why it is erroring...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks