Excel VBA Examples

How to Select Only Bold Cells in Excel

This post will guide you how to select only bold cells in a range of cells in Excel. How do I select all bold cells in a given range using VBA Macro in Microsoft Excel 2013/2016. Select Only Bold Cells Using Find And Replace Select Only Bold Cells Using VBA Assuming that you have a… read more »

How to Open an Excel Workbook to a Specific Worksheet

This post will guide you how to activate a specific worksheet when an Excel Workbook opens. How to use an Excel VBA Macro to specify a specific worksheet to open for a Microsoft Excel Workbook in Excel 2013/2016. Open an Excel Workbook to a Specific Worksheet Assuming that you have a big workbook file and… read more »

How to Replace Zeros with Blank Cells in Excel

This post will guide you how to replicate zeros with blank cells in a selected range in Excel. How do I convert cells containing zero with blank cells ┬áin selected range in an Excel Worksheet. Replace Zeros with Blank Cells with Find and Replace Function Replace Zeros with Blank Cells with VBA Macro Assuming that… read more »

How to Clear or Disable the Recent Workbook List in Excel

This post will guide you how to clear or disable the recent workbook list in Excel 2013/2016. How do I clear Recent Document lists with VBA macro in the Microsoft Excel. Clear Recent Workbook List Using Excel Options Clear Recent Workbook List Using Unpinned Workbooks Clear Recent Workbook List Using VBA Macro When using Excel… read more »

How to Save File based on Cell Value in Excel

This post will guide you how to save Excel workbook file with Cell value in Excel. How do I save file using cell contents as file name with VBA Macro in excel. Save File Based on Cell Value Assuming that you have a request that save the current workbook file I am working as the… read more »

How to Convert mmddyy to Date in Excel

This post will guide you how to convert non-standard date formats or text to a standard date in Excel. If you have a date with mmddyy format, and you want to change it as the normal date format as mm/dd/yyyy with Excel Formula. How do I convert the mmddyyyy text to normal date format in… read more »

How to Popup Message Box When Opening A Workbook in Excel

This post will guide you how to create a pop up message box when you open a workbook in Excel. How do I create a message box in Excel using VBA and pop up whenever you open your workbook or excel file in Excel. Display Message Box When Opening a Workbook If you want to… read more »

How to Open Multiple Hyperlinks at Once in Excel

This post will guide you how to open multiple links at once in Excel. How do I open multiple Hyperlinks with VBA Macro in Excel. Open Multiple Links at Once Assuming that you have a list of data which contain multiple hyperlinks and you want to open those links at once in your current worksheet…. read more »

How to Save or Export Each Sheet to Separate CSV Files in Excel

This post will guide you how to save each worksheet to separate CSV files in your workbook in Excel. How do I save multiple or all worksheets to separate csv file in Excel 2013/2016. How to export all worksheets to separate txt files with VBA macro in Excel. Export Each Sheet to Separate CSV Files… read more »

How to Select Entire Column except Header Row in Excel

This post will guide you how to select entire column except header or first row in Excel 2013/2016. How do I select whole column except first header cell with VBA Macro in Excel. How to use shortcut keys to select entire column in Excel. Select Entire Column except Header Row with Shortcut Select Entire Column… read more »

Sidebar