The following code only works when I activate and select the workbook and sheet it applies to.
Workbooks(sWorkbookToSort).Sheets(sSheetToSort).Range("B2:C2").AutoFill Destination:=Range(Cells(2, 2), Cells(iMaxRow, 3)), Type:=xlFillDefault
How could I get around that?
Workbooks(sWorkbookToSort).Sheets(sSheetToSort).Range("B2:C2").AutoFill Destination:=Range(Cells(2, 2), Cells(iMaxRow, 3)), Type:=xlFillDefault
How could I get around that?