Forum Discussion

Iron Contributor

Jul 29, 2021

Solved

Question related to VBA

Hello Everyone, I am trying to remove one single row above the active cell, is there a VBA code for the same? For example i may be in cell B66 or F15. If i have to delete the entire row immediately...

excel

Macros and VBA

Subodh_Tiwari_sktneer
Jul 30, 2021
Excel
LONG is the numerical data type and Dim r AS LONG means the variable r will hold the numerical value.
I could write the code without declaring any variable but I did it to make it easy for you to follow so that you can tweak it yourself if required.

Alternatively, you may try one line of code to do this...
Sub DeleteRows() Rows(ActiveCell.Row - 1).Delete End Sub

If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.

Subodh_Tiwari_sktneer

Silver Contributor

Jul 29, 2021

Excel

You may try something like this...

The following code will delete the row from the ActiveSheet.

Sub DeleteRow()
Dim r As Long
r = ActiveCell.Row - 1
Rows(r).Delete
End Sub

Excel
Iron Contributor
Jul 30, 2021
Sir, why we use LONG as declaration?
What is the use of LONG in VBA code?
- Subodh_Tiwari_sktneer
  Silver Contributor
  Jul 30, 2021
  Excel
  LONG is the numerical data type and Dim r AS LONG means the variable r will hold the numerical value.
  I could write the code without declaring any variable but I did it to make it easy for you to follow so that you can tweak it yourself if required.
  
  Alternatively, you may try one line of code to do this...
  Sub DeleteRows() Rows(ActiveCell.Row - 1).Delete End Sub
  
  If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.
  - Excel
    Iron Contributor
    Jul 30, 2021
    Thank you so much sir😊