Copy to last used row
Posted by Andonny on May 24, 2001 3:11 AM
I read the thread about array formulas and I just would like to say that I have been very happy with all answers from everybody.
I learnt a lot and I like to use array and non-array formulas. I also learnt from the thread what they have various influences and I am glad for the explenations.
My question this time is how to copy an array formula down to the last row used.
Usually I use following but it doesn't seem to work for array formulas.
Range("A1", Range("A65536").End(xlUp)).Offset(0, 1).FormulaR1C1 =
Thanks a lot for your help