Hello Gavin
I had some issues a while ago (topic1397.html#p6327) getting my VBA code to fire. As I moved to other software for a while, I forgot about this. I've now rewritten the workbook from scratch, and the problem persists - Cymatic does not recognise that cells in BA:BC have been populated or updated by VBA. I threw together a sample workbook to test a few code samples, and narrow down the possibilities. In short, using formulas in BA:BC works fine. Using VBA to populate two or more columns does not work - Cy does not process or accept the commands, unless I edit one of the cells in BA:BC (for example by double-clicking then pressing enter). For reference, I use the exact same code, but with different cell references on other software, and it works as expected. That narrows it down to an issue with Cymatic, or an issue with Cy and the version of Excel I'm using. Windows 7, Excel 2007 with SP1 update.
**I've tried to attach the workbook, but .xlsm attachments are not allowed
Cheers
adenlark