Macros & Excel VBA

Excel VBA to Hide Columns Based on Cell Value (15 Examples)

Sometimes, we need to hide columns based on some specific cell value. It is a pretty common task. In this article, we are going to demonstrate 15 ...

How to Remove Gridlines in Excel Using VBA

By default, the Gridlines are shown as gray lines in an Excel file. Those lines help us better visualize the data. However, we may want to disable ...

Excel VBA to Hide Columns Based on Criteria (6 Useful Examples)

Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. Moreover, VBA is another cool ...

Excel VBA to Open Workbook in Background (2 Useful Examples)

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. Another cool feature is ...

How to Find Special Characters Using VBA in Excel (3 Quick Ways)

The article will show you how to find special characters in Excel using VBA. Special characters can be any characters other than uppercase or ...

How to Hide Rows with Zero Values in Excel Using Macro (3 Ways)

Data is getting bigger each and every day. We need to find ways to view large datasets easily and using Excel VBA Macros can save a ton of time. In ...

How to Change the Column Header Name in Excel VBA – 3 Examples

This is an overview. This is the sample dataset. Example 1 - Change the Column Header Name Based on the Cell Property This ...

How to Save Chart as Image Using VBA in Excel (2 Easy Methods)

The article will show you how to save a chart as an image in Excel by using VBA. In general, you can save a chart as an image from the Context Menu ...

How to Insert Page Break Based on Cell Value with Excel VBA

Often, we need to add page breaks in Excel to differentiate values. This is also very helpful for printing purposes. This indicates where one page ...

Excel VBA: Print Preview for Selected Range (5 Examples)

The article will show you some methods on how to print previews for a selected range of cells in Excel by using Microsoft Visual Basic for ...

Excel VBA to Convert Textbox Value to Number (2 Ideal Examples)

In this article, we will learn to convert the textbox value to a number with VBA in Excel. A textbox is a rectangular box that displays different ...

VBA Code to Compare Two Excel Sheets and Copy Differences

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. Sometimes, we have to make ...

Auto Generate Serial Number in Excel VBA (4 Ways)

The sample dataset Customer Credentials, into which serial numbers are to be inserted adjacent to those entries.   Method 1 - Using ...

Excel VBA to Capitalize First Letter of Each Word (3 Ideal Examples)

When adding certain information to an Excel sheet, such as company names or employee names, we may want to capitalize the first letter of each word. ...

Excel VBA: If Statement Based on Cell Value (2 Practical Examples)

In this article, I’ll show you how you can use an If statement in VBA in Excel based on a cell value. Excel VBA: If Statement Based on Cell ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo