-
autofilling formulae across columns
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
-
[VBA]Range(cells(1,1),cells(1,columns.Count).end(xltoleft)).Formula =[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules