Hi, I hope this makes sense. I have live data fed into sheet1. I have
code in Worksheet-change. When the cide fires I use
Application.enableEvents = false - do my calcs - then reset Events to
true. My data starts at range("a8"), results of calcs are displayed in
range("a4"). Today it started ok, link was working fine. Until, I
decided I wanted my data to start at range("a2"). So, before
connecting the live data, I deleted the existing data, saved the
workbook then connected the live data. The connection doesnt work now.
Ive tried reinstalling excel, the program that collects the dat etc.
Is there away to check that I ve enabled events propely.
Regards Robert