View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Use formulas for array elements

Hi hmm,

Sounds like you are asking how to cross the river
rather than explaining the entire journey. It may be
that you don't need to cross that river.

Please give more precise details about what
you are trying to achieve.

HTH
Martin


"hmm" wrote in message
...
I want to make a matrix calculation using an array that is not a range of
cells, but contains formulas. For example, it could be {1; A1; A1^2},
except
that only constants can be placed in array brackets.

Is there a way of entering such an array, without using a range of cells
to
enter the formulas?