Controling cell references in formulas written from VBA
 

John,
No, and that was the problem. The form was called from a click event
handler on an embedded chart. When I selected a cell in the form
code, everything worked OK. Then after the formula was written, I
re-selected the chart object.
Thanks.

"jaf" wrote in message ...
Hi Ken,
Both a Worksheet_Activate event module and an embedded CommandButton on a
worksheet would tell Excel what the active sheet is by default. Are you
activating the worksheet in your form code?