'Add use sheet names to navigate to relevant worksheetsĪctiveWorkbook.Sheets(source(i)).Activate 'Define number of iterations based on raw datasets 'Add User Defined sheetnames to source Collection 'Add Manufacturer Column Refs to manufacturer_col Collectionįor Each key In Range('manufacturer_cols').Cells

Any help would be appreciated! Private Sub RemoveManufacturers()Īpplication.Calculation = xlCalculationManualĪctiveWorkbook.Sheets('settings').Activateįor Each key In Range('manufacturers').Cells I haven't done any VBA programming for 5 years or so. My Macro seems to work but eventually crashes Excel. There is a settings page where the user defines the worksheets that include the datasets, the first cell in the column to check in each dataset and also the list of strings to check against and these are all called as defined named ranges. The number of datasets can differ each time and the columns to check will be different in each dataset. I'm using a VBA script to automate deleting rows of different datasets in Excel based on whether a cell in a certain column matches a predefined list of strings (names of manufacturers).

Excel for mac 2016 crashing