Thread: Names
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Howard Brazee Howard Brazee is offline
external usenet poster
 
Posts: 68
Default Names

On Fri, 21 Aug 2009 12:06:01 -0700, Luke M
wrote:

Ah, 2007. I'm afraid I'm still using 2003, so I'm not quite sure what the new
layout looks like. In the hopes that Microsoft kept the same shortcut keys,
you could try pressing Ctrl+F3. That, at least it used to be, is the shortcut
to bring up the dialogue.


Ctrl-F3 works. It shows for "tax"
=Data!$I$67

So I edited it to
=Data!$I67

Then I referenced tax =IF(H670,F67-tax-K67-H67,""). The number is
right but I got a ! and a triangle showing an error.

I then copied that cell up one row. That fixed it, apparently my
version of Excel thinks I have an error if cells look different.

Thanks.

--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison