Runtime error 91 although object variable is set

Hi!

I'm experiencing some issues with my code which is suppose to retrive data from yahoo finance.

Receives error code 91 object variable or with block variable not set and highlight row "If target.Row = rng.Row And target.Column = rng.Column Then".

As I see it I have set target as range.

Any ideas?

Thanks in advance!



Here is my code;

Please Login or Register  to view this content.

Above that line of code you have not yet "SET Target = ????" to anything.

No, only you know what the value A1 on sheet1 is being compared to, what is it?

It is suppose to be a stock ticker, for instance AAPL.

The logic is that you are putting in a ticker and the macro go to yahoo finance to search for it.
I have pretty much copied all from a youtube video, only difference is that he is using Sub Worksheet(ByVal target as range).

----Update----

Here is the youtube link if anyone elese is interested https://youtu.be/PPaMZ-WN5So?t=574

Yes, a worksheet_change macro is a self-targeted macro. It is triggered when a cell's value is physically changed by VBA or by hand. Once the value has changed, the macro is initiated and the "Target" is automatically defines as the "the cell that changed value".

I apologize for not having time to further investigate your macro until tomorrow. In the meantime, here's a FUNCTION I know that works.

Please Login or Register  to view this content.

Install that into a standard code module (module1, module2, etc) and then you will have a new function available in your spreadsheet. Assuming you have GOOGL for instance in A1, then this formula in B1 would pull back that stock's price:

=SHAREPRICE(A1)

Mr. JBeaucaire
I tried your great UDF function but I got NAME error
Any suggestion about that error