Create your first Excel macro. Here you will learn how to type a macro in Excel 2007, Excel 2010 & in Excel 2013. You will learn how to display the Developer tab in Excel 2007 and in Excel 2010 and 2013. You will learn how to create your Personal Macro Workbook if you don't already have this workbook. This ensures you can create and save macros that will be automatically accessible to you whenever you launch Excel. Then learn how to create the new macro, how to make sure it is saved in your Personal Macro Workbook and how to enter the code in the Visual Basic Editor. Then see how to save the macro and how to run it.
With this knowledge you can then make macros from any code that you find on the web and in books.
Here is the code for this macro - you can copy and paste it from here:
Sub removerows()
On Error Resume Next
Columns("a").SpecialCells(xlBlanks).EntireRow.Delete
End Sub
VIEW MORE VIDEOS JUST LIKE THIS ON MY YOUTUBE CHANNEL
Subscribe ► http://www.youtube.com/subscription_c...
VISIT PROJECTWOMAN.COM FOR MORE ON PHOTOSHOP, ILLUSTRATOR & LIGHTROOM Website ► http://www.projectwoman.com
Blog ► http://www.projectwoman.com/phototips
SUBSCRIBE TO MY EMAIL MAILING LIST
http://visitor.constantcontact.com/d....
LET'S CONNECT!
Google+ ► https://plus.google.com/+helenbradley
Facebook ► / projectwoman
Twitter ► / helenbradley
LinkedIn ► / helenbradley
LEARN BY PURCHASING ONE OF MY COURSES
Udemy ► https://www.udemy.com/illustrator-for...
Curious ► https://curious.com/helenbradley/seri...
Curious ► https://curious.com/helenbradley/seri...
Skillshare ► http://www.skillshare.com/helenbradley
Learn Lightroom with Helen Bradley ► http://helenbradley.teachable.com
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE THESE MICROSOFT OFFICE VIDEOS:
Create Your First Access Database - Pt 1 - Table Design ► • Create Your First Access Database - P...
Create Your First Access Database - Pt 2 - Queries ► • Create Your First Access Database - P...
Create Your First Access Database - Pt 4 - Report Design ► • Create Your First Access Database - P...
eBook Template in Word ► • Fast and Easy eBook Template in Word
Word 2013 - What's new ► • Learning Word 2013 - How to Use New T...
Word page nos columns and orientation ► • Change Page Numbering - Columns & Ori...
Create Your First Access Database - Pt 3 - Form Design ► • Create Your First Access Database - P...
Move an image in a Word Document ► • Move an image in a Word Document - se...
Microsoft Word - Rotate Text ► • Rotate Text in Microsoft Word - verti...
Microsoft Office - Recolor Clip Art ► • Learning Microsoft Office - Recolor C...
Excel - Use Spin Button for Data Entry ► • Learning Excel: Use Spin Button for D...
Excel - Replace charts with pictures ► • Learning Excel - Replace charts with ...
Watch video Excel - Create Your First Macro - Learn to create a macro by entering code in the VB Editor online without registration, duration hours minute second in high quality. This video was added by user Helen Bradley 22 April 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 113,354 once and liked it 126 people.