Macros & Excel VBA

VBA Paste Special to Copy Values and Formats in Excel (9 Examples)

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

Macro to Delete Columns in Excel (10 Methods)

When we have a large amount of data with lots of unnecessary columns in our Excel worksheet, it is hard to understand sometimes. If we remove the ...

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 Apply VBA PasteSpecial and 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 of them, 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 (A Detailed 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 ...

On Error Resume Next: Handling Error in Excel VBA

In Microsoft Excel VBA, error handling is one of the critical tasks. If you are a coder, you know the importance of error handling to build a perfect ...

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

In this article, we’ll illustrate how to delete a sheet if 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 more 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. Count 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 (VBA), this is the right ...

How to Delete Column and Shift Left Using VBA in Excel (5 Methods)

While working with a large Microsoft Excel, sometimes unnecessary data will appear in front of us, and we need to delete those unnecessary data in ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo