| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format range of cells for Array formula
what is the quickest way to select a range of cells with formulas and convert
them to array formula format? hitting F2 and ctrl+shift+enter takes forever. thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format range of cells for Array formula
maybe this but maybe you could change one manually and copy down.?
for each c in range("a2:a22") c.FormulaArray = c.Formula Next c -- Don Guillett SalesAid Software "Knox" wrote in message ... what is the quickest way to select a range of cells with formulas and convert them to array formula format? hitting F2 and ctrl+shift+enter takes forever. thank you! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format range of cells for Array formula
Awesome! that worked. No, for some reason I can't copy down that particular
format. thanx "Don Guillett" wrote: maybe this but maybe you could change one manually and copy down.? for each c in range("a2:a22") c.FormulaArray = c.Formula Next c -- Don Guillett SalesAid Software "Knox" wrote in message ... what is the quickest way to select a range of cells with formulas and convert them to array formula format? hitting F2 and ctrl+shift+enter takes forever. thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Array Range & Individual Cells | Excel Discussion (Misc queries) | |||
| Redefine range of cells, array formula returns NA | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
| Copying array formula to a range of cells... | Excel Programming | |||
Linear Mode
