Runtime Error '424' Object Required Error Vlookup Help - ExcelVbaIsFun QnA
📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
In this video, Robert keeps getting a runtime error 424 with "Object Required" when he wants to do a vlookup with vba. Check out the hidden but simple solution!
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/
Пікірлер: 12
Thanks for the video!
@ExcelVbaIsFun
10 жыл бұрын
You're very welcome and thank you! Dan
Been there. Sometimes it is the easiest things that make our debugging difficult. Your eyes just scan right over that assuming it is correct. I find if I have difficulties with some code, I normally take a break from it and return later with fresh eyes and then find it. Or send it to Dan to figure out. :)
@ExcelVbaIsFun
10 жыл бұрын
LOL!!! Thanks krn. So true, it's always better if you can get away for a sec. . . Dan
hi, your videos taught me a lot about vba, my question is is there a code that makes activex button to work like a hyper link?. i.e. when I click the button it get me to different part of of a sheet?
@ExcelVbaIsFun
10 жыл бұрын
Where there's a will, there's a way, monta. Where do you want it to take you to when you click, for example? Dan
@monta1994
10 жыл бұрын
for example when I click the button it would send me to sheet2 cell b25.
@ExcelVbaIsFun
10 жыл бұрын
monta1994 I'll show you, uploading new vid tonight. Dan
@monta1994
10 жыл бұрын
OMG. :D :D :D
@ExcelVbaIsFun
10 жыл бұрын
monta1994 :) Dan
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan