Store array of relative cells in a cell

[Johnado]

How can you store an array of relative cells in a cell, for example:

Please Login or Register  to view this content.

I want to reference the cell as the source for an axis.

[tim201110]

you can use an array

[FDibbins]

John, welcome to the forum

Can you be a bit more detailed in what it is you are trying to do?
(Tim, that is already an array)

[Johnado]

You can do "={1,2,3}", but doing "={C1,C2,E4}" gives an error. Is there a way to do array constants with relative cells?

[FDibbins]

On its own, "={1,2,3}" will give you 1. what exactly are you trying to do?

[tim201110]

i meant an array in VBA

[FDibbins]

i meant an array in VBA

Still does not really explain how to do what you are suggesting?