Correct cell value doesn't display

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Parsons - 08 Jan 2008 16:39 GMT

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

Reply to this Message

Niek Otten - 08 Jan 2008 16:56 GMT

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!

Signature

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
[quoted text clipped - 12 lines]
|
| Joe Parsons

Reply to this Message

Joe Parsons - 09 Jan 2008 03:39 GMT

>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

Reply to this Message