How to Read Data Type Stocks

[OldSwimmer1650]

Cells F13:F18 are created by = E13.[Ticker symbol] by using Data Types - Stocks

I'm writing VBA code to FIND a specific ticker symbol, say for example MRNA, in the range F13:F18

This is the code I have so far:


Sub FindIfNew()

Dim CheckCell As Range
Dim c As Range

Set c = Range("f13:f18")
Set CheckCell = c.Find("MRNA")
Debug.Print CheckCell.Address

End Sub



The code works if the stock symbols are typed in the cell, but doesn't work if the cell is generated by = E13.[Ticker symbol]

I'm assuming that the Data Type Stocks is the culprit.

 

[Peter_SSs]

Before embarking on a new one, I'm wondering how we went with your last question?

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to Read Data Type Stocks
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[OldSwimmer1650]

Before embarking on a new one, I'm wondering how we went with your last question?

Cool on the crossposting, but I'm confused. Is the link XLB2BB the answer to my current question?

 

[starkc69]

Cool on the crossposting, but I'm confused. Is the link XLB2BB the answer to my current question?

Click on his link -- How to Read Data Type Stocks

 

[OldSwimmer1650]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to Read Data Type Stocks
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thank you for updating me on the procedures. I confess I didn't read the rules as I was in a hurry to get something completed. I know better... I'd don't want to waste peoples time, as these boards are invaluable. I'm going to post the same exact text on Excel Forum as I was bad there too. You want me to post a crosspost link to my apology there too? LOL

I appreciate your time very much!