Macros & Excel VBA

Text Alignment with VBA Command Button in Excel (5 Methods)

In this article, we will learn text alignment with the command button in Excel using VBA. Text alignment is a necessary thing to represent a clean ...

How to Delete Columns Based on Header Using VBA in Excel

In general, Excel workbooks contain numerous columns. Sometimes, by the time some columns become redundant. So, we need to delete those columns. We ...

Excel VBA to Copy Data from Another Workbook without Opening

In Microsoft Excel, VBA Macros can easily solve a wide range of problems. If we want to copy data from another workbook without opening the workbook, ...

VBA Paste Special to Copy Values and Formats in Excel

When we need to copy and paste any data in Microsoft Excel, we have the facility of different shortcuts and ribbon tools in Excel. Excel VBA Macro ...

VBA to Count Duplicates in Range in Excel (4 Methods)

When we have a large amount of data in our Excel worksheet, it is hard to understand sometimes. If we have a certain knowledge of how many duplicate ...

VBA to Copy Formula from Cell Above in Excel (10 Methods)

When we are dealing with a huge amount of data with various formulas, sometimes we have to copy data with formulas from the cell above in an Excel ...

How to Use VBA PasteSpecial to Keep Source Formatting in Excel

However, there are situations when we want to duplicate more than simply text. We can copy all of Excel's capabilities, such as conditional ...

AutoFill Formula to Last Row with Excel VBA (5 Examples)

If you are working with Microsoft Excel for a while, you know the importance of AutoFill. In order to copy a formula across the row or the column, we ...

Copy and Paste Values to Next Empty Row with Excel VBA (3 Examples)

You can copy and paste data in several ways in Excel. Using the VBA code to copy and paste values with conditions can automate a lot of steps and ...

How to Delete Hidden Rows in Excel VBA (Step-by-Step Analysis)

In this article, I’ll show you how you can delete hidden rows from a worksheet with VBA in Excel. You’ll learn to delete hidden rows from both a ...

Excel VBA: Delete Sheet If It Exists (4 Methods)

In this article, we’ll illustrate how to delete a sheet if it exists from a workbook using VBA in Excel with 4 examples. As deleting worksheets is a ...

How to Delete Row Using Macro If Cell Contains 0 in Excel (4 Methods)

Frequently you may need to omit unnecessary cells containing specific cell values that are no longer useful for you. For example, you might delete ...

How to Count Filled Cells in Excel Using VBA (7 Methods)

Excel VBA is a strong tool to execute any operations. Counting filled cells (ignoring blanks or empty cells) in Excel VBA is a common operation to ...

Calculate Number of Days Between Two Dates with VBA in Excel

While working with dates with VBA in Excel, we often have to calculate the number of days between two dates. In this article, I’ll show you how you ...

How to Copy Worksheet to Another Workbook Using VBA

If you want to copy your Excel worksheet to another workbook or to a new workbook with Microsoft Visual Basic Application, this is the right place ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo