VBA - Determining which cell in a column contains the value from a different cell

[parkerbelt]

I have a spreadsheet that has a value stored in cell M7 which is 201601.
I want to evaluate all the cells in column C beginning at Cell C19 and going down or coming up from the bottom and stopping at C19. and when a match is found 201601, I want to get the cell letter and number - like C35.

 

[mumps]

Try:

Sub FindCellAddr()
    MsgBox Range("C19:C" & Range("C" & Rows.Count).End(xlUp).Row).Find(Range("M7"), LookIn:=xlValues, lookat:=xlWhole).Address(0, 0)
End Sub

 

[parkerbelt]

Worked beautifully. Thank you!!

Try:

Sub FindCellAddr()
    MsgBox Range("C19:C" & Range("C" & Rows.Count).End(xlUp).Row).Find(Range("M7"), LookIn:=xlValues, lookat:=xlWhole).Address(0, 0)
End Sub

 

[mumps]

You are very welcome.