| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically copying array formulas
It appears when I programmatically copy an array formula using something like
this: r.formular1c1 = r.offset(-1,0).formular1c1 'where r is a range. The array formulas need to be committed with CTRL SHIFT ENTER. Is this happening to anyone else? What do I need to do to get these to copy correctly? FWIW, I'm still using 2003. Thanks, Barb Reinhardt |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programmatically copying array formulas
Try,
r.FormulaArray = r.Offset(-1, 0).FormulaArray Mike "Barb Reinhardt" wrote: It appears when I programmatically copy an array formula using something like this: r.formular1c1 = r.offset(-1,0).formular1c1 'where r is a range. The array formulas need to be committed with CTRL SHIFT ENTER. Is this happening to anyone else? What do I need to do to get these to copy correctly? FWIW, I'm still using 2003. Thanks, Barb Reinhardt |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programmatically copying array formulas
Is there some way to determine if I need to use FormulaArray
programmatically. For now, I'm just doing it on certain columns. Thanks, Barb Reinhardt "Mike H" wrote: Try, r.FormulaArray = r.Offset(-1, 0).FormulaArray Mike "Barb Reinhardt" wrote: It appears when I programmatically copy an array formula using something like this: r.formular1c1 = r.offset(-1,0).formular1c1 'where r is a range. The array formulas need to be committed with CTRL SHIFT ENTER. Is this happening to anyone else? What do I need to do to get these to copy correctly? FWIW, I'm still using 2003. Thanks, Barb Reinhardt |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programmatically copying array formulas
Hi,
If r.HasArray Then 'copy array style else 'copy non array style end if Mike "Barb Reinhardt" wrote: Is there some way to determine if I need to use FormulaArray programmatically. For now, I'm just doing it on certain columns. Thanks, Barb Reinhardt "Mike H" wrote: Try, r.FormulaArray = r.Offset(-1, 0).FormulaArray Mike "Barb Reinhardt" wrote: It appears when I programmatically copy an array formula using something like this: r.formular1c1 = r.offset(-1,0).formular1c1 'where r is a range. The array formulas need to be committed with CTRL SHIFT ENTER. Is this happening to anyone else? What do I need to do to get these to copy correctly? FWIW, I'm still using 2003. Thanks, Barb Reinhardt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Array Formulas | Excel Discussion (Misc queries) | |||
| Programmatically copying charts and cells from Excel into PowerPoi | Charts and Charting in Excel | |||
| Programmatically calculating formulas for new entries | Excel Programming | |||
| Can't programmatically set a large array string to a range. | Excel Programming | |||
| copying data from an unopened file programmatically | Excel Discussion (Misc queries) | |||
Linear Mode
