Refreshing cell value

J

Joe Parsons

I am developing a spreadsheet in Excel 2007 that uses Goal Seek in a VBA macro.
It does what I need it to do, except that the new value placed into the "By
Changing" cell doesn't appear unless I navigate to another sheet or hit F2 to
edit it.

The Macro is

Range("diff").GoalSeek Goal:=0, ChangingCell:=Range("NewLoan")
Range("NewLoan").Select

The value does appear in the formula bar.

Am I missing something in the basic configuration of Excel? Spreadsheets
developed in Excel 97 using the same routine work fine.

Joe Parsons
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MAcro help 0
Goal seek - column reference 3
macro Help 3
Debug problem 3
Correcting "Circular Action" in Worksheet_Change 2
Goal seek - column reference - user input message 0
Loop several sheets - part 3 - Dave Peterson - Goal seek 4
Loop several sheets - part 4 - Dave Peterson - Goal seek 1

Top