autofill range to last row in column for specific worksheets
Posted on 2014-02-03
I have a number of active worksheets in Wb"A". I would like the macro to run for specific worksheets named, Sheet1, Sheet4, Sheet8.
In each named sheet, the macro should fill down the columns D-H to the last row in Column A, starting at the last row in Columns D-H.
e.g. if the last row in column A is 200 and the last row in Columns D-H is 150, then the macro should fill down D150-H200.
The macro should then repeat for all the named sheets in the workbook.