No refresh in copied cell

A

Auke

Hi,

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

Any ideas?

Thanks in advance.
 
D

Dave Peterson

Make sure you have calculation set to automatic.

tools|Options|calculation tab
 
Top