Microsoft KB Archive/71493

{| = POKE Function Example in Q+E Manual Is Incorrect =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q71493

SUMMARY
Page 78 of the &quot;Q+E for Microsoft Excel User's Guide&quot; for version 3.00 shows an incorrect example for using the POKE function to send data to Q+E.

If you enter the formula exactly as it is in the manual, the macro will display #REF! as a result for the cell containing the POKE function.

MORE INFORMATION
The POKE function has three parameters:

=POKE(channel_num,item,data) Removing the quotation marks from around the data parameters will allow the POKE function to operate correctly. The following example will show the correct entry: =POKE(chan,&quot;R1C1:R2C1&quot;,C1:C2) The data parameter references C1:C2 on the macro sheet that contains values that will be inserted in the first column of rows 1 and 2 in the Query window in Q+E.