I need to have two different Worksheet_Change Events for one worksheet. I now know that there is a limit of one per sheet.
I thought I would be slick and just set up a helper sheet to mirror the one I need to watch by pasting a link to the target range. Then setup a Worksheet_Change Event on the helper worksheet. But even though the helper sheet linked cells do change, the the Worksheet_Change Event does not trigger.
Does anyone have any good workarounds for this?
thanks
Robert
Bookmarks