VBA macro doen't works properly


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.




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: 1969) 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: 4729) 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 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