Hello everyone!
I hope you can help me with this code fragment: I want to see for each cell if its corresponding C column value contains a specific word. The code below gives the error message: Method Range of object _Global failed. Do you know how should it look like in order to work? Thanks
![]()
Dim r As Range For Each r In ActiveSheet.UsedRange If Range("C" & r).Value = "word"
Bookmarks