Excel - Create Your First Macro - Learn to create a macro by entering code in the VB Editor
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 ...
Смотрите видео Excel - Create Your First Macro - Learn to create a macro by entering code in the VB Editor онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Helen Bradley 22 Апрель 2013, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 113,354 раз и оно понравилось 126 людям.