Array (Control Shift Enter)

[Steved]

Hello from Steved

Is there away where I can Highlight E2:J8
and Make These cells Array or do I have to do them cell by
cell (Control Shift Enter)Key.

Thankyou.

 

[Bob Phillips]

Hello Steve,

There may be a worksheet way, but you could try this bit of code

Dim cell As Range

For Each cell In Selection
cell.FormulaArray = cell.Formula
Next cell


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Steved]

Thankyou Bob.

-----Original Message-----
Hello Steve,

There may be a worksheet way, but you could try this bit of code

Dim cell As Range

For Each cell In Selection
cell.FormulaArray = cell.Formula
Next cell


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.