Trying to use VB --"Change Event" ie Worksheet_(ByVal target_etc etc
to look for incomming data sent by PLC to spread sheet via excel link.
---
the change event works correctly in the spreadsheet except when activated by Excell link. When this happens no data comes into the spread sheet from the PLC. If I disable the Macro then the excell link works ok but ,the macro doesnot.
Any Ideas
Bill