LinkBack URL
About LinkBacks
the change event is not triggered by a formula recalculation so as mentioned you need to monitor the input cell (F4) instead
or use the worksheet_calculate event
If Target.Address(False, False) = "F4" Then
the change event is not triggered by a formula recalculation so as mentioned you need to monitor the input cell (F4) instead
or use the worksheet_calculate eventIf Target.Address(False, False) = "F4" Then
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks