{"id":18377,"date":"2020-07-04T05:47:00","date_gmt":"2020-07-04T03:47:00","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=18377"},"modified":"2024-05-22T20:46:34","modified_gmt":"2024-05-22T18:46:34","slug":"101-excel-macros-examples","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/","title":{"rendered":"101 Excel Macros Examples"},"content":{"rendered":"<p>Macros are one of the most powerful features in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a> and learning how &amp; when to use them will make you into an Excel superstar!<\/p>\n<p>There are 101 ready-to-use Macros in this post for you to become more efficient at <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a>!<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Why_VBA\" title=\"Why VBA?\">Why VBA?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#List_of_101_Excel_Macros_Examples\" title=\"List of 101 Excel Macros Examples\">List of 101 Excel Macros Examples<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Advanced_Macros\" title=\"Advanced Macros\u00a0\">Advanced Macros\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Basic_Macros\" title=\"Basic Macros\u00a0\">Basic Macros\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Chart_Macros\" title=\"Chart Macros\u00a0\">Chart Macros\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Formula_Macros\" title=\"Formula Macros\u00a0\">Formula Macros\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Highlighting_Macros\" title=\"Highlighting Macros\u00a0\">Highlighting Macros\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Pivot_Table_Macros\" title=\"Pivot Table Macros\u00a0\">Pivot Table Macros\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Printing_Macros\" title=\"Printing Macros\u00a0\">Printing Macros\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Tips_and_Tricks\" title=\"Tips and Tricks\u00a0\">Tips and Tricks\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Workbook_Macros\" title=\"Workbook Macros\u00a0\">Workbook Macros\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/#Worksheet_Macros\" title=\"Worksheet Macros\u00a0\">Worksheet Macros\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Why_VBA\"><\/span>Why VBA?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Do you repeat various Excel actions like copy &amp; pasting data, formatting, hiding and unhiding worksheets, to name a few?<\/p>\n<p>Did you know that you can automate your tasks in Excel with a couple of mouse clicks?<\/p>\n<p>If you keep on repeating the same thing over and over again,\u00a0creating an\u00a0Excel VBA Macro\u00a0is perfect for you!\u00a0 It saves you time so you can do things that you like doing, like going home early!<\/p>\n<p>VBA stands for <strong>Visual Basic for Applications<\/strong>. Visual Basic (VB) is a programming language from Microsoft used to create your own custom applications.<\/p>\n<p>VBA on the other hand, is a smaller version of VB that is included in each <a class=\"wpil_keyword_link\" title=\"Microsoft Office\" href=\"https:\/\/www.office.com\/\" target=\"_blank\" rel=\"noopener nofollow\" data-wpil-keyword-link=\"linked\">Microsoft Office<\/a> application, <strong>Excel being one of them<\/strong>. With VBA, you do not need to pay somebody to custom program for your additional functionalities that you need in Excel. You can create your own by combining VBA and Excel!<\/p>\n<p>A common scenario is when you take 30 minutes each day to prepare and format a report. \u00a0You can use VBA Macros to reduce this work to a single button click! The time savings just stack up and your boss will be impressed with your efficiency.<\/p>\n<p>Not satisfied with the coverage of Excel functions? You can create your own Excel user-defined function using VBA. You can then repeatedly use your user-defined function in the spreadsheet.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"List_of_101_Excel_Macros_Examples\"><\/span>List of 101 Excel Macros Examples<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div>\n<div>\n<div class=\"table-of-contents\" id=\"table_of_contents\" ><br \/>\n<div class='content-column one_half'><p><span style=\"color: #0000ff;\"><i class=\"fa fa-arrow-circle-up \" ><\/i> <strong><a href=\"#section01\">Advanced Macros<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-desktop \" ><\/i> <strong><a href=\"#section02\">Basic Macros<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-table \" ><\/i> <strong><a href=\"#section03\">Chart Macros<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-flask \" ><\/i> <strong><a href=\"#section04\">Formula Macros<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-bars \" ><\/i> <strong><a href=\"#section05\">Highlighting Macros<\/a><\/strong><\/span><\/p><\/div><div class='content-column one_half last_column'><p><span style=\"color: #0000ff;\"><i class=\"fa fa-table \" ><\/i> <strong><a href=\"#section06\">Pivot Table Macros<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-print \" ><\/i> <strong><a href=\"#section07\">Printing Macros<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-bolt \" ><\/i> <strong><a href=\"#section08\">Tips and Tricks<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-book \" ><\/i> <strong><a href=\"#section09\">Workbook Macros<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-book \" ><\/i> <strong><a href=\"#section10\">Worksheet Macros<\/a><\/strong><\/span><\/p><\/div><div class='clear_column'><\/div><br \/>\n<\/div>\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n<p><a href=\"https:\/\/shop.myexcelonline.com\/\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18398 size-full\" title=\"101 Excel Macros Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Macro-E-book-Ad.png\" alt=\"101 Excel Macros Examples\" width=\"1800\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Macro-E-book-Ad.png 1800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Macro-E-book-Ad-300x100.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Macro-E-book-Ad-1024x341.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Macro-E-book-Ad-768x256.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Macro-E-book-Ad-1536x512.png 1536w\" sizes=\"(max-width: 1800px) 100vw, 1800px\" \/><\/a><\/p>\n<\/div>\n<\/div>\n<p>Click on any <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/enable-or-disable-macros\/\" target=\"_blank\" rel=\"noopener\">Excel macro<\/a> link below and it will take you to the free example tutorial &amp; downloadable Excel workbook for you to practice!<\/p>\n<\/div>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***Watch it on <a href=\"https:\/\/youtu.be\/V6bLATFw4Vw\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/V6bLATFw4Vw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/VBAIntroduction.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/VBAIntroduction.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">VBAIntroduction.xlsm<\/span><\/a><\/p>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/yLcQv7Uxlas\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/yLcQv7Uxlas?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/ProtectUnprotect.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/ProtectUnprotect.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">ProtectUnprotect.xlsm<\/span><\/a><\/p>\n<\/div>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/dsmm4tBkoqw\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/dsmm4tBkoqw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/RefreshPivotTable.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/RefreshPivotTable.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">RefreshPivotTable.xlsm<\/span><\/a><\/p>\n<\/div>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/LF-FbNwnYk8\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/LF-FbNwnYk8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/VBAPart4CategoryCount.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/VBAPart4CategoryCount.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">VBAPart4CategoryCount.xlsm<\/span><\/a><\/p>\n<\/div>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/VGCtTCSCsDc\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/VGCtTCSCsDc?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/5-FilterBySalesPersonAndExport.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/5-FilterBySalesPersonAndExport.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">5-FilterBySalesPersonAndExport.xlsm<\/span><\/a><\/p>\n<\/div>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/srpJ-J6qjnY\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/srpJ-J6qjnY?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/6-ImportFile.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/6-ImportFile.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">6-ImportFile.xlsm<\/span><\/a><\/p>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/yPN-Z0_ndrM\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/yPN-Z0_ndrM?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/ChangeRowColor.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/ChangeRowColor.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">ChangeRowColor.xlsm<\/span><\/a><\/p>\n<\/div>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/_g_GQD8D3xw\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/_g_GQD8D3xw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/VBAStrings.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/VBAStrings.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">VBAStrings.xlsm<\/span><\/a><\/p>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/C9U3xp1-64I\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/C9U3xp1-64I?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/VBAStrings.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/VBAStrings.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">VBAStrings.xlsm<\/span><\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Advanced_Macros\"><\/span><span style=\"color: #ff0000;\"><a id=\"section01\"><\/a>Advanced Macros\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-selected-range-into-an-image-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Convert Selected Range into an Image Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-text-into-speech-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Convert Text into Speech Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-table-of-contents-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create a Table of Contents Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-a-linked-image-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Insert a Linked Image Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/save-selected-range-as-pdf-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Save Selected Range as PDF Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-goal-seek-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Use Goal Seek Using Macros In Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Basic_Macros\"><\/span><span style=\"color: #ff0000;\"><a id=\"section02\"><\/a>Basic Macros\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-custom-footer-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Custom Footer Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-custom-header-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Custom Header Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-date-in-footer-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Date In Footer Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-date-in-header-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Date In Header Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-autofit-columns-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Autofit Columns Using Macros in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-autofit-rows-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Autofit Rows Using Macros in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-multiple-columns-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Insert Multiple Columns Using Macros in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-multiple-rows-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Insert Multiple Rows Using Macros in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-numbers-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Insert Numbers Using Macros in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-text-wrap-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Remove Text Wrap Using Macros in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-swap-values-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Swap Values Using Macros in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unmerge-all-cells-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Unmerge All Cells Using Macros In Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Chart_Macros\"><\/span><span style=\"color: #ff0000;\"><a id=\"section03\"><\/a>Chart Macros\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-chart-title-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Chart Title Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/change-chart-type-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Change Chart Type Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-chart-into-image-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Convert Chart into Image Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/resize-all-charts-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Resize All Charts Using Macros In Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Formula_Macros\"><\/span><span style=\"color: #ff0000;\"><a id=\"section04\"><\/a>Formula Macros\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-a-degree-symbol-to-selection-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add a Degree Symbol to Selection Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-formulas-into-values-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Convert Formulas into Values Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-selection-to-lower-case-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Convert Selection to Lower Case Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-selection-to-proper-case-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Convert Selection to Proper Case Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-selection-to-sentence-case-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Convert Selection to Sentence Case Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-selection-to-upper-case-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Convert Selection to Upper Case Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/protect-all-cells-with-formulas-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Protect All Cells With Formulas Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-characters-at-the-start-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Remove Characters at the Start Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-extra-spaces-from-selection-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Remove Extra Spaces from Selection Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/reverse-text-function-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Reverse Text Function Using Macros In Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Highlighting_Macros\"><\/span><span style=\"color: #ff0000;\"><a id=\"section05\"><\/a>Highlighting Macros\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-active-row-column-by-double-click-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Active Row &amp; Column by Double Click Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-all-errors-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight All Errors Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-all-named-ranges-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight all Named Ranges Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-alternate-rows-in-selection-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Alternate Rows in Selection Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-and-count-a-specified-value-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight and Count a Specified Value Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-cells-with-a-single-space-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Cells with a Single Space Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-cells-with-comments-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Cells with Comments Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-custom-text-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Custom Text Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-duplicates-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Duplicates Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-max-value-in-selection-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Max Value in Selection Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-min-value-in-selection-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Min Value in Selection Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-negative-values-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Negative Values Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-top-10-values-of-selection-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Top 10 Values of Selection Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-unique-values-in-selection-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Unique Values in Selection Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-values-greater-than-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Values Greater Than Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-values-lesser-than-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight Values Lesser Than Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/spell-check-and-highlight-misspellings-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Spell check and Highlight Misspellings Using Macros In Excel<\/a><\/div>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/shop.myexcelonline.com\/\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13266 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png\" alt=\"101 Macros Book\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-1024x536.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-768x402.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" title=\"\"><\/a><\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Pivot_Table_Macros\"><\/span><span style=\"color: #ff0000;\"><a id=\"section06\"><\/a>Pivot Table Macros\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/disable-enable-get-pivot-data-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Disable\/Enable Get Pivot Data Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/hide-pivot-table-subtotals-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Hide Pivot Table Subtotals Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/refresh-all-pivot-tables-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Refresh All Pivot Tables Using Macros In Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Printing_Macros\"><\/span><span style=\"color: #ff0000;\"><a id=\"section07\"><\/a>Printing Macros\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/print-all-comments-of-a-worksheet-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Print All Comments of a Worksheet Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/print-the-selected-area-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Print the Selected Area Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/print-with-a-narrow-margin-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Print with a Narrow Margin Using Macros In Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Tips_and_Tricks\"><\/span><span style=\"color: #ff0000;\"><a id=\"section08\"><\/a>Tips and Tricks\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-macro-activate-the-developer-tab\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Macro: Activate the Developer Tab<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-add-a-macro-to-the-quick-access-toolbar-ribbon-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Add a Macro to the Quick Access Toolbar Ribbon in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-create-your-first-macro-button-in-excel-beginners-tutorial\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Create Your First Macro Button in Excel &#8211; Beginners Tutorial<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-macro-recorder-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Use Macro Recorder in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/macro-recorder-recording-your-first-excel-macro\/\" target=\"_blank\" rel=\"noopener noreferrer\">Macro Recorder: Recording Your First Excel Macro<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/put-a-macro-in-the-quick-access-toolbar\/\" target=\"_blank\" rel=\"noopener noreferrer\">Put a Macro In The Quick Access Toolbar<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-calculator-by-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Use Calculator By Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/where-to-store-your-vba-macro-in-this-workbook-or-personal-macro-workbook\/\" target=\"_blank\" rel=\"noopener noreferrer\">Where To Store Your VBA Macro In? This Workbook or Personal Macro Workbook<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Workbook_Macros\"><\/span><span style=\"color: #ff0000;\"><a id=\"section09\"><\/a>Workbook Macros\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/attach-current-workbook-into-an-email-message-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Attach Current Workbook into an Email Message Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/close-all-workbooks-and-save-changes-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Close\u00a0All Workbooks and Save Changes Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/copy-current-worksheet-into-a-new-workbook-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Copy Current Worksheet into a New Workbook Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-backup-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create a Backup Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/get-the-count-of-unsaved-workbooks-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Get the Count of Unsaved Workbooks Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-a-closing-message-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Show a Closing Message Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-a-welcome-message-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Show a Welcome Message Using Macros In Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Worksheet_Macros\"><\/span><span style=\"color: #ff0000;\"><a id=\"section10\"><\/a>Worksheet Macros\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-all-other-worksheets-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Delete All Other Worksheets Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-blank-worksheets-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Delete Blank Worksheets Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/hide-all-other-worksheets-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Hide All Other Worksheets Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-multiple-worksheets-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Insert Multiple Worksheets Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/protect-active-worksheet-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Protect Active Worksheet Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/protect-all-worksheets-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Protect All Worksheets Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/save-each-worksheet-as-a-pdf-file-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Save Each Worksheet as a PDF File Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-all-worksheets-by-name-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sort All Worksheets By Name Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unhide-all-hidden-rows-and-columns-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Unhide All Hidden Rows and Columns Using Macros In Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unhide-all-worksheets-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Unhide All Worksheets Using Macros In Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unprotect-active-worksheet-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Unprotect Active Worksheet Using Macros In Excel<\/a><\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>\n<div>\n<p><a href=\"https:\/\/shop.myexcelonline.com\/\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13266 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png\" alt=\"101 Macros Book\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-1024x536.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-768x402.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" title=\"\"><\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Macros are one of the most powerful features in Excel and learning how &amp; when to use them will make you into an Excel superstar! There are 101 ready-to-use Macros in this post for you to become more efficient at Excel! Why VBA? Do you repeat various Excel actions like copy &amp; pasting data, formatting, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":18427,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"101 Excel Macros Examples","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[56,647,639,640,641,642,643,644,648,645,646],"tags":[661,662,106,361],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/18377"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=18377"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/18377\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/18427"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=18377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=18377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=18377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}