Thread: What does allcalc (a table_array) refer to in a cell formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default What does allcalc (a table_array) refer to in a cell formula?
I would assume it is a named range for the lookup table range

Do you see it when you click on the NameBox?

or nder InsertNameDefine.........2003

or FormulasDefine Name..........2007


Gord Dibben MS Excel MVP


On Tue, 29 Sep 2009 13:55:01 -0700, Seabreezin
wrote:

I'm using a spreadsheet that looks up data in different worksheets. The term
"allcalc" is used. A cell's formula reads:

=+HLOOKUP($C$9,allcalc,driver!$A$35,FALSE).

"driver" is the name of the worksheet, what does allcalc do?

Reply With QuoteReply With Quote