2007 Update

[Alectrical]

Hi
When I was working with Excel 2003, the following code worked, where two DDE
links in B1 and B2 changed value every second and the new values were updated
in columns C and D, where each value was incremented to produce a range of
values suitable for charting.

After upgrading to Excel 2007, the graph stopped working and I keep getting
the following error message:-

"A formula in this worksheet contains one or more invalid references. Verify
that your formulas contain a valid path, workbook, range name, and cell
reference."

Private Sub Worksheet_Calculate()
On Error Resume Next
Cells(Rows.Count, 3).End(x1Up).Offset(1, 0) = Range("B1") 'Box Temp
Cells(Rows.Count, 3).End(xlUp).Offset(1, 1) = Range("B2") 'Reference Temp
End Sub

Thanks in Advance
Alec

 

[Don Guillett]

Could be as simple as 1 <>L

 

[Alectrical]

Thanks for your reply Don, but I don't understand your explanation, could you
explain it further.

Thanks Again
Alec

 

[Don Guillett]

End(x1Up).