ListenData

Home » VBA

Showing posts with label VBA. Show all posts

VBA : ActiveWorkbook Vs ThisWorkbook

This tutorial explains the difference between ActiveWorkbook and ThisWorkbook in VBA. When multiple workbooks are open in Excel, the diff...

This tutorial explains how to delete a row in Excel using VBA. You can download the following dataset to practice. Download Excel Fil...

This tutorial explains how to find last visible row using VBA code in Excel. You can download the following dataset to practice. Down...

This tutorial explains how to concatenate strings in Excel using VBA code. You can download the following dataset to practice. Downlo...

This tutorial explains how to remove special characters in Excel using VBA. The following VBA code loops through column A and checks if it ...

This tutorial explains how to add comments in VBA code. Comments are used to add explanations or notes within the code. They do not affect ...

This tutorial explains how to filter data using VBA in Excel. You can download the following dataset to practice. Download Excel File...

This tutorial explains how to sort data in Excel using VBA. You can download the following dataset to practice. Download Excel File ...

This tutorial explains how to use NOT LIKE in VBA. The NOT LIKE is used to check if a string does not match a specified pattern. There is...

This tutorial explains how to use Like Operator in VBA. Like Operator is used to compare a string against a pattern. Syntax of Like Oper...

This tutorial explains how to use wildcards in VBA, along with examples. Wildcard characters are used to represent one or more characters i...

This tutorial explains how to unhide one or multiple columns in Excel using VBA. You can download the following dataset to practice. ...

This tutorial explains how to unhide one or more rows in Excel using VBA. You can download the following dataset to practice. Downloa...

This tutorial explains how to unhide sheets in Excel using VBA. Syntax to Unhide a Sheet The following VBA code unhides the sheet named ...

This tutorial explains how For Each loop works in VBA and how we can use it in Excel. For Each Loop is a loop that iterate over each elemen...

This tutorial explains multiple ways to remove duplicates in Excel using VBA code. You can download the following dataset to practice. ...

This tutorial explains how to identify duplicates in one or more columns using VBA in MS Excel. You can download the following dataset to p...