Programmatically copying array formulas

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

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
 
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
 
Hi,

If r.HasArray Then
'copy array style
else
'copy non array style
end if

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy used range from one worksheet to another (and lose the pivot) 3
Extract Comments to Cell and search with AutoFilter 2
copying an array formula 2
copy an array formula 1
Copy Array to Array, how to and should I? 13
Copy as Picture takes up to 5 seconds to copy 4
VBA - Multiple Array-Enter Command 1
Formula Array Macro 5

Back
Top