F4 & K10 are updated by BAspreadbetting wrote: ↑Mon Jul 02, 2018 3:04 pmI don't use BA but what gets sent to those cells? Wsheet_change won't recognise a calculate event, do they contain formulas rather than having data sent to them?
You can always switch them within the code toCode: Select all
If Range("L10").Value ="whatever you're looking for" Then
mmm
I had something like If Range.Value <> Last RangeValue Then before and just blazed round a loop. It worked but I was trying to be more efficient by detecting just changes because I was finding that after 30mins the sheet was getting slower and slower to be updated. Toggling DDE in the options restores the speed but it's hardly practical.
The problem seems to be that Target is being returned as the whole sheet range changing, not just cells 1 by 1. I might need an Intersect or something.
One for later anyway...thx.