autofill with dynamic range
Anita,
To fill to match the column to the left, select the cell (either in Excel or in Code), then ActiveCell.AutoFill Destination:=Range _ (ActiveCell, ActiveCell.Offset(0, -1).End(xlDown)(1, 2)) HTH, Bernie Excel MVP "a" wrote in message ink.net... Can anybody help me with an autofill with a dynamic range. A long time ago Tom Ogilvy gave me this code so that I could copy a formula down to the bottom of a column I was hoping that I could use it to use the autofill - but I have no idea how to do that. Intersect(Range(ActiveCell, _ Cells(Rows.Count, ActiveCell.Column)), _ ActiveCell.CurrentRegion).FillDown I have to do an autofill for 8 columns and do a sort after each and so any help with the autofill on a dynamic range would be great. As always - thanks in advance, Anita |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com