Excel Macros - Button, Assign to Macro to Delete Blank Rows - Excel VBA Part 13

Learn how to create buttons in Excel that will trigger macros. We'll first create a quick macro to delete blank rows from our data and then we'll assign the macro to a button,

This tutorial is Part 13 from Excel VBA Programming - Beyond Recording Macros series.

#excel #macro #vba

[mohammadaijaz]

Sir Please upload more VBA assignments video tutorials, you are a great teacher of excel.

[reallyefficient]

You rock! Thanks again for such clear, concise videos!!

[hoiyinwan]

You are very talented, thank you for showing us these techniques.

[wlad]

i been leaning a lot with your videos. Will you upload the continuation of these vba programming? Thanks for the tutorials

[FredericBiondi]

Excellent video. Thank you so much for your hard work.

[financialgyaan]

Hi Admin, I want to hear it from you - what do you objectively think is a better software for 3 categories :
1) A pro user (way way advance level)
2) A not so pro user (somewhere in the middle)
3) Literally Basic stuff user.

[KhuramImtiaz]

Excellent video. I have learned so much from you videos. Is there a way to do the same in Googlesheets. e.g can we hide or display a macro button using app script in Googlesheets

[Vacar]

Sub removeBlanks()
Dim intRow As Integer
Dim intLastRow As Integer
intLastRow = ActiveSheet.UsedRange.Row + _
- 1
Range("A1:C" & intLastRow).RemoveDuplicates 1, xlYes ' Array(1, 2)
For intRow = intLastRow To 1 Step -1
If ActiveSheet.Rows(intRow).Text = "" Then

End If
Next intRow
End Sub


stop using .Select

[MuhammadAkbar-geyt]

The purpose of those videos is to teach, not to run through the things without explaining. On the other hand if you post videos with an intention to trying to show that you are master then I am moving on.