how to delete certain rows in excel using a macro

HOW TO DELETE CERTAIN ROWS IN EXCEL USING A MACRO CODE

RowIndex = FindRow(range, timeStampValue) Let's spin through the entire file and delete these rows with // cell 1 found in any row except at the top Will change according to your report // and what values you would like to searchĬellOneValue1 = ' Inventory Master File' cellOneValue2 = ' From Store' ĬellOneValue_Line1header = ' Item' cellOneValue_Line2header = ' Number' An if loop is used to add the values to the other strings // if its condition is met if (reportName = ' Inventory Master File') String cellOneValue_Line2header = string.Empty ĬellOneValueTimeStamp=timeStampValue // It will be same for all reports // This is a hard coded value // The reportName, may differ for your file, // is set to the string 'Inventory Master File' String cellOneValue_Line1header = string.Empty

String.Empty string cellOneValueTimeStamp = string.Empty

HOW TO DELETE CERTAIN ROWS IN EXCEL USING A MACRO CODE

Let's hardcode cell1 values for each report // These variables will be used later in the code string cellOneValue1 = string.Empty string cellOneValue2 = The timestamp value is set to the time that the data is updated String timeStampValue = GetCell(range, 1, 1) // Grab time stamp // The reportName variable is set to an empty string String reportName = string.Empty // here insert report name // Let's delete the heading except header line 1 now // Delete 1 - Delete first Row 2 - int rowsToBeDeleted = 0 The range is set to the range of rows that have information typed inĮxcel.Range range = clsWorksheet.UsedRange (Excel.Worksheet)clsWorkbook.ActiveSheet

Opens up the worksheet and activates it string mySheet = '*Insert path of Excel file*' // Initialize Excel object library var excelApp = new .Application()

How to delete certain rows in excel using a macro