Correct cell value doesn't display

[Joe Parsons]

I am creating 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

 

[Niek Otten]

Hi Joe,

There was a similar (not exactly the same) issue using Tables. It was solved in SP1. Try downloading SP1 and try again.
On my system, which has SP1 installed, I can't reproduce your problem.

Please post back your results!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am creating 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

 

[Joe Parsons]

Hi Joe,

There was a similar (not exactly the same) issue using Tables. It was solved in SP1. Try downloading SP1 and try again.
On my system, which has SP1 installed, I can't reproduce your problem.

Please post back your results!

I checked, and I already have all the latest updates.

Joe Parsons