Excel Question

Discussion in 'Programming' started by Gammahedge1, Feb 12, 2013.

  1. I'm pretty sure this is a rudimentary Excel question but here goes. I have this worksheet calculate code in Excel that takes an instance in Cell A1 and populates the data into cell B2, B3, B4 etc etc every 1 minute (I'm using IB's DDE API to grab whatever data I'm looking to capture out of cell A1). What I want to do is also grab other data and do the same thing in Cell D & E, Cell G & H and so on. It doesn't work at all when I try to run the code in the other cells. I've attached the worksheet so if anyone has any idea's I'd really appreciate it!