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?

No.

"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?

On Mon, 3 Dec 2007 02:33:01 -0800, hmm wrote:

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?

You cannot do it with an array constant in Excel. However, you could write a
user-defined function using VBA to do something like this.
--ron

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?