I'm having trouble getting an iferror function to work in VBA. The function works fine when entered in the cell itself, but i would like it to run with my sub so i don't have to manually drag down the function.
above is my code. The iferror is looking across 5 other sheets: IDO_supplier, Clear_assy, etc. I would like it to populate in the ALLmissed sheet. when i run it, i am getting an object defined error.
Please Login or Register to view this content.
appreciate any help!
Double up any quotes within the formula:
This:
Please Login or Register to view this content.
becomes this:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for the fast response TMS. I'm having one more issue now. The cell that im searching (D2) is staying consistent, but i would like for it to search for the cell which row it is in. So $D2 was just the first row. Is there a way to have that change to search the cell in column D of the current row each time? Like it does when I enter the function and manually drag down in the actual sheet?
Thanks again!
Two ways to do it.
1) use R1C1 rather than A1 format
2) change all the $D2 references to: $D" & index & ". So, you're actually changing the 2 to " & index & "
Regards, TMS
Thanks a ton!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks