close

Hi,

I have made some references to other cells in other worksheets in my
workbook through VBA: worksheet.cells.formula = quot;= 'otherworksheet'!C2quot;
But when I update the source cell, the target cell doesn't automatically
refresh.

Any ideas?

Thanks in advance.

Make sure you have calculation set to automatic.

tools|Options|calculation tabAuke wrote:
gt;
gt; Hi,
gt;
gt; I have made some references to other cells in other worksheets in my
gt; workbook through VBA: worksheet.cells.formula = quot;= 'otherworksheet'!C2quot;
gt; But when I update the source cell, the target cell doesn't automatically
gt; refresh.
gt;
gt; Any ideas?
gt;
gt; Thanks in advance.

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄