Thread: No refresh in target cell when using worksheet.cells.formula = ...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
galimi[_2_] galimi[_2_] is offline
external usenet poster
  
Posts: 65
Default No refresh in target cell when using worksheet.cells.formula = ...
Ensure that calculation is set to Automatic.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Auke" wrote:

Hi,

I have made some references to other cells in other worksheets in my excel
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.
Reply With QuoteReply With Quote