MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy to last used row


Posted by Andonny on May 24, 2001 3:11 AM

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


Posted by David Hawley on May 24, 2001 3:32 AM


Hi Andonny

For some arrays you need to use another method:


Range("B1").FormulaArray = "=IF(OR(RC[-1]:R[2]C[-1]=1,RC[-1]:R[2]C[-1]=2),1,"""")"
Range("B1").AutoFill Range("B1:B" & Range("A65536").End(xlUp).Row)

Dave

OzGrid Business Applications