Hello,

The code below is supposed to loop through rows in column A and then loop through the worksheets in the open workbook and replace the value it finds in column A with column B.
Logically it makes sense to me but the code is not doing its job in replacing the values in the other open workbooks. It is, though, replacing the values in its own workbook.
Sub WBLoop()

Dim rcell As Long
Dim wb As Workbook: Set wb = ThisWorkbook
Dim wsm As Worksheet: Set wsm = wb.Sheets("BrandList")
Dim ws As Worksheet
Dim wbk As Workbook

For rcell = 1 To 1200
    For Each wbk In Workbooks
        For Each ws In wbk.Worksheets
            Cells.Replace What:=wsm.Range("A" & rcell).Value, Replacement:=wsm.Range("B" & rcell).Value, LookAt:=xlWhole, _
            SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False
        Next
    Next
Next

End Sub
I would really appreciate any light on this.

Thank in advance