Private Sub Worksheet_Change(ByVal Target As Range)

[PIM499]

Hi, I have a sports draw spreadsheet that allows the entry of a result and a manual copy of the winner's name into the next round column. This cell change kicks off the Worksheet_Change code which automatically updates my website and sends an email to the winner and next opponent. All works well.
However I tried to change my manual copy and paste of the winner's name with the following: =IF(AND(J20="",J24=""),"", IF(J20="w/o",I20, IF(J24="w/o",I24, IF(J20>J24,I20, IF(J24>J20,I24, ))))). This works but the winners name landing in the next round cell doesn't kick off the Worksheet_Change code. I need to add that the Worksheet_Change checks for numeric value or blank entered and goes to the end of the Sub.
Has anyone any suggestions how I can keep my Worksheet_Change AND initiate from the =IF( function?
Hope this makes sense. If you need to see any code in my Worksheet_Change sub I can provide it, however it is a bit long!

[Leith Ross]

Hello PIM499,

Welcome to the forum!

Formula calculations do not trigger Worksheet_Change events, only user input and VBA code that changes a cell's value will.

When you have time, please read the Forums Rules. It will help you get answers to your questions faster.

[Alf]

Perhaps you could try something like:

Please Login or Register  to view this content.

where B15 contains a formula and the you need a macro to check B15

Please Login or Register  to view this content.

Alf