I am using the below code to drag the contents of the range selected down to the last row populated (as dictated by value in Col A). It works fine on the active sheet.
However it does not work when I want to perform across multiple sheets within the same workbook within the one function. Eg to perform the below function on every sheet within the workbook (about 80 sheets), where on each sheet the last row is variable.
Any assistance would be appreciated. Thanks
Dim Column_o_o As Long
Column_o_o = Range("A" & Rows.Count).End(xlUp).Row
Range("o22:q22").AutoFill Destination:=Range("o22:q" & Column_o_o), Type:=xlFillSeries
However it does not work when I want to perform across multiple sheets within the same workbook within the one function. Eg to perform the below function on every sheet within the workbook (about 80 sheets), where on each sheet the last row is variable.
Any assistance would be appreciated. Thanks
Dim Column_o_o As Long
Column_o_o = Range("A" & Rows.Count).End(xlUp).Row
Range("o22:q22").AutoFill Destination:=Range("o22:q" & Column_o_o), Type:=xlFillSeries