Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

VBA macro doen't works properly

0

Dear Excel Specialists,

I run the attached VBA macro, just with "beta" value to be picked up at YahooFinance.com, and it works perfectly.

I added one more variable "ttm" following the same process, i get this message:

=> Run-time error"91": Object variablenot set.

I tried several item numbers and commands "get...", but as the wished value is at first position inside the table, then item should be 0...

I put some screenshoot attached to support your understanding of my issue.

Thank you in advance.

Laurent. 

excel
posted by: Laurent on Fri Apr 23, 2021 at 12:31 pm
Answer
Discuss

Discussion

Hi there Laurent! Images will not post here, but you can edit your question and add the code that you are using and that's very helpful to understand the issue, just make sure to paste the code between the CODE tags that appear after you click the CODE button.
don (rep: 1989) Apr 23, '21 at 2:20 pm
It's always better to have the code within the question itself for ease of copying as well as prmilinary reading. But the very next thing we almost invariably do is to ask for a copy of the workbook so that we can see the context. You can't attach an image file here because it can't serve either purpose but in Edit mode you can also attach a workbook.
Variatus (rep: 4889) Apr 23, '21 at 7:55 pm
Hi, Thank you for your feedback.
I fianly switch to google sheet, and i got what i wanted.
Thanks again for your nice support.
Laurent.
Laurent May 2, '21 at 1:11 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login