OldSwimmer1650
New Member
- Joined
- Dec 3, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
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.