Hi all
Earlier today RoyUK supplied me with this code for updating a worksheet when a cells content changes. This works fine but I now need to have a 2nd worksheet update itself when the cell in another worksheet changes.
To clarify, I need Worksheet1 to update itself when cell B2 in worksheet2 changes.![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$B$2" Then Exit Sub ActiveSheet.Calculate End Sub
TIA ...spellbound
Bookmarks