View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Auke Auke is offline
external usenet poster
 
Posts: 3
Default No refresh in target cell when using worksheet.cells.formula =

Yes, Charlie, they did all the things right, you can also see the formula in
the formula bar, but it doesn't update.

cheers

"Charlie" schreef:

Has the procedure been run, and did it put the forumlas where you expected
them to be?

"Auke" wrote:

it is! That's what is confusing

"galimi" schreef:

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.