Array (Control Shift Enter)

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
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)
 
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)




.
Click to expand...
 
Back
Top