What data type are letters?

[benpatz]

I want to find Lg in my worksheet1. I was wondering what data type I would use?
Every data type i have found has been to do with numbers.

Just beginning,
thanks,

 

[shg]

String

 

[benpatz]

I'd like to find out how to search through my excel worksheet and find a string and have excel report back to me what cells those are that have the value. Some of the arguments in this code I am not familiar with. But the problem I am having is the code only searches the first cell.

Sub usingfind()
Dim oWrSht As Worksheet
Dim lastrow As Long, i As Long, c As String


Dim MyCell As Range
Set oWrSht = Sheets("Sheet1")


lastrow = oWrSht.Range("A" & Rows.Count).End(xlUp).Row


c = "Lg"


Set MyCell = oWrSht.Range("C1:C" & lastrow).Find(what:=c, LookIn:=xlValues)


If Not MyCell Is Nothing Then
MsgBox "Value found in cell" & MyCell.Address
End If
Exit Sub

 

[My Aswer Is This]

Try this:
Run this script from the Sheet named Sheet1

Sub Find_Me()
'Modified  8/7/2018  10:30:37 PM  EDT
Application.ScreenUpdating = False
Dim r As Range
Dim aaa As String
Dim anss As String
Dim Lastrow As Long
Dim SearchValue As String
Lastrow = Cells(Rows.Count, "C").End(xlUp).Row
SearchValue = InputBox("Enter search for value")
    For Each r In Sheets("Sheet1").Range("C1:C" & Lastrow)
        If r.Value = SearchValue Then ans = ans & "  " & r.Address & vbNewLine
    Next
    If ans = "" Then MsgBox "Value  " & SearchValue & "  Not Found": Exit Sub
    anss = "The value  " & SearchValue & " found here"
    
    aaa = Replace(ans, "$", "")
    MsgBox anss & vbNewLine & aaa
Application.ScreenUpdating = True
End Sub