JZB
06-09-2009, 12:32 AM
hi guys
can you confirm the quickest way i can autofill a formula across columns.
I know how to autofill down to the lastrow
Range("AI2:AI" & Cells(Rows.Count, "A").End(xlUp).Row).Formula =
but how do get this to run across the s/sheet
Thanks
Jon
can you confirm the quickest way i can autofill a formula across columns.
I know how to autofill down to the lastrow
Range("AI2:AI" & Cells(Rows.Count, "A").End(xlUp).Row).Formula =
but how do get this to run across the s/sheet
Thanks
Jon