VbA Specific cell in each sheet during a worksheet loop

[Kelly05201]

This is so simple, and it's making me feel like the newbie I am. What is the proper syntax for this example?

Sub findthatvalue ()

Dim wks As Worksheet
Dim Third As String
For Each wks In Worksheets
Third = [cell "H77" on whatever sheet the loop is currently looking at]
MsgBox (Third)
Next wks
End Sub

hey... I'm humble and we all start somewhere.
TIA !

 

[Norie]

Try this.

Sub findthatvalue ()

Dim wks As Worksheet
Dim Third As String

    For Each wks In Worksheets
        Third = wks.Range("H77").Value ' 
        MsgBox (Third)
    Next wks

End Sub

 

[Kelly05201]

"Type mismatch" - 13

 

[Norie]

I only get that error when H77 on one of the sheets contains an error value.

 

[Kelly05201]

I only get that error when H77 on one of the sheets contains an error value.

I went through 6 bottles of vodka just for you to tell me THAT? I swear if you had a dollar for every silly mistake you've helped people through....
THANK YOU, again. You're a saint.