tarzan538
05-11-2010, 12:40 PM
I have a worksheet where I take a group of cells (column GG) and via a button I send these values to a PLC (programable logic controller). I do not understand why it won't allow me to send more that 5 rows. If instead of L5 I put L6 then value # 6 won't go through.
Existing and fucntional array:
DDEPoke RSIchan, "CIP1.StringArray7[0],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[5],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG14:GG18")
DDEPoke RSIchan, "CIP1.StringArray7[10],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[15],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[20],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[25],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[30],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[35],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
Existing and fucntional array:
DDEPoke RSIchan, "CIP1.StringArray7[0],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[5],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG14:GG18")
DDEPoke RSIchan, "CIP1.StringArray7[10],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[15],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[20],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[25],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[30],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[35],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")