How to delete or remove empty or blank rows in excel using vba
How to delete or remove empty or blank rows in excel using Visual Basic for Applications (VBA)
Hello everyone, welcome to Excel 10 Tutorial. I'm your trainer kazi and lets get started.
Step 1: First Click on the Developer tab
Here's how to add developer tab if you don't have it in your Ribbon: • How to add developer tab in excel
Step 2: Now Click on Visual Basic. A popup window will open.
Step 3: Click on Insert and then Module.
Step 4: Write the VBA code. (Please subscribe and here goes the code: / 26491751 )
Step 5: Click on the Run button
Step 6: Select the data range from where you want to remove the empty rows.
Step 7: Click OK and close the visual basic window.
Done. You've successfully deleted blank rows from your selection.
#removerows #vba
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $1
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial Become a member and enjoy exclusive perks while supporting the channel you love!
/ @excel10tutorial