| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Brackets {}
Hello From Steved
Please is their away off highlighting a worksheet and then changing all the formulas to anarray {} please as there are abot 70 or so do to and I'm hoping to avoid doing it Manually. Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Array Brackets {}
Dim c As Range
For Each c In ActiveSheet.UsedRange If c.HasFormula Then c.FormulaArray = c.Formula End If Next c -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Steved" wrote in message ... Hello From Steved Please is their away off highlighting a worksheet and then changing all the formulas to anarray {} please as there are abot 70 or so do to and I'm hoping to avoid doing it Manually. Thankyou. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Array Brackets {}
Thankyou
"Bob Phillips" wrote: Dim c As Range For Each c In ActiveSheet.UsedRange If c.HasFormula Then c.FormulaArray = c.Formula End If Next c -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Steved" wrote in message ... Hello From Steved Please is their away off highlighting a worksheet and then changing all the formulas to anarray {} please as there are abot 70 or so do to and I'm hoping to avoid doing it Manually. Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with brackets | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| =D6-E6 there are brackets? | Charts and Charting in Excel | |||
| Array brackets | Excel Worksheet Functions | |||
| Tournament Brackets | New Users to Excel | |||
Linear Mode
