VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft. It is now mainly used with Microsoft Office applications such as MS Excel, MS-Word and MS-Access. It is associated integrated development environment (IDE). Although Visual Basic is no longer. Here users get several functions to complete the work in perfect flow. We know that technical students need additional guidance and direction while writing the assignment. Here we are also trying to give them complete support with our writers and they are ready to give the quality information to students through VBA assignment help.

Simple Process to Delete the Row

VBA Code to Delete entire row: Here is the VBA delete whole row macro Syntax and Example VBA Macro code to Delete Entire Row from excel worksheets. This will support you to know the process, how to delete complete row from Excel workbook using VBA.

VBA Delete Entire Row: Syntax: Following is the VBA delete complete row macro Syntax and sample VBA macro instruction to Delete Entire Row from worksheet using VBA. We are using the Delete technique of the Rows object of worksheet.

Rows (

[Row Number]). EntireRow.Delete

Here Row Number is your row number to delete. And EntireRow.Delete method will Delete Entire Row from the Excel spreadsheet.

Delete Entire Row using VBA: Examples

  • The following Excel VBA delete entire row macro code is to delete entire row from the worksheet

Sub sbVBS_To_Delete_EntireRow ()

Row (1). EntireRow.Delete

End Sub

Instructions to run the VBA Macro code to delete Entire Row

Please follow the below phases to perform the VBA delete entire row macro.

Step1: Open any existing Excel workbook.
Step 2: Now Alt+F11 – This will open the VBA
Step 3: Insert a code module from then insert menu.

Step 4: Copy the above code and paste in the code module which have inserted in the above step.
Step 5: enter some sample data in row 1.
Step 6: Now press F5 to execute the code

Now you can observe that the entire row 1 is deleted from worksheet.

Explained VBA Code to Delete Entire Row:

Starting program and sub procedure to write VBA code to delete entire row from sheet.
Sub sbVBS_To_Delete_EntireRow_C ()

Now specify the row number that you want to delete.

Ending the sub procedure to delete entire row.
End Sub

VBA to Delete Entire Row in Excel: Using for Loop – Explanation

Here is the detailed explanation of the delete row using for loop in VBA.

Starting the sub procedure to write VBA macro to delete rows using VBA for loop.
Sub sbVBS_To_Delete_EntireRow_For_Loop_C()
‘Declaring the variable into CTR to store the for loop iterations.
Dim iCntr
‘looping through the rows using for loop, here step statement indicates the iCntr increment.
For iCntr = 1 To 10 Step 1
‘deleting the first row.
Rows(1).EntireRow.Delete
Next

We have deleted the first row 10 times, that means we have deleted the first 10 rows in excel sheet using for loop and VBA.
End Sub

Simplest and Easiest Method to Get the Best Assignment Solutions from Professional Writers of BookMyEssay

With the support of our best online facility students directly chat with the writers. Our the best Australian writers are completely ready to deliver the best support and guidance to students 24*7. They never ignore the students queries and provide the best solutions to them through homework help. Have trust on us and collect the best assistance!! We never cheat with students and provide the all possible best support to them according to the university requirements directly from free assignment help sites.