Macros & Excel VBA

Excel VBA Codes to Bold Text in a String (5 Examples)

Changing font styles while working with Microsoft Excel is one of the familiar tasks. We perform this in Excel day-to-day. Changing the font style to ...

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, ...

How to Copy Values and Formats with Paste Special in Excel VBA

Method 1 – Applying an InputBox in VBA Paste Special Steps: Go to the Developer tab. Click on Record Macro. Set Excel_Paste_Special_1 ...

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)

Method 1 - Copy a Range of Cells and Paste Values from the Next Empty Row in Excel Using VBA Code In this particular example, we will copy row 11 ...

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 ...

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 ...

VBA to Copy Worksheet to Another Workbook and Rename (5 Methods)

When we are dealing with multiple Excel sheets, sometimes we need to copy one worksheet to another workbook and provide a new name to it for better ...

Macro to Copy and Paste from One Worksheet to Another (15 Methods)

When we are dealing with multiple Excel sheets, sometimes we have to copy data from one spreadsheet to another. Implementing VBA is the most ...

How to Delete Duplicate Rows in Excel with VBA (8 Effective Ways)

In this article, we will learn to delete duplicate rows in Excel with VBA. VBA gives us the opportunity to perform any tasks according to the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo