loop through open workbooks and replace values

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.

Please Login or Register  to view this content.

I would really appreciate any light on this.

Thank in advance

Try changing 'Cells.Replace' to 'ws.Cells.Replace'

I could use an EMOJI that slaps his forehead with his hand! I can't believe i missed that one!

Thanks!