In this article, we will have a look at how to synchronize the data between two cells / ranges / columns or rows using VBA. Of course, you can use cell reference to do the same, but in cases where you need to use VBA,
In this article we will see how to delete columns in Excel using VBA. Example 1: Delete an entire column in a sheet using column number: Say, the Excel data that is of the form below and you need to delete the column for May-18
In this tutorial we will see how to create a user form using VBA and dynamic combo boxes to it. The input sheet contains a number of drop downs with varying number of options in each, as seen below: Using VBA, we will create two
In this article we will look at how to find duplicate entries across columns using Excel VBA. Consider you have 3 columns of data with few duplicate rows as seen below: And you need to highlight the rows that are not unique. As there is no
In this article we will see how to copy data from multiple Excel workbooks and paste it to a new Excel Workbook. Consider you have three Excel workbooks with data in a single sheet with the same name. The range from which data is to
In this article we will look at how to copy values from multiple worksheets to other worksheets within the same file based on a condition using Excel VBA. Consider you have monthly sheets (named Jan, Feb, Mar and so on) that contain stock prices as
“Next Without For” Compile Error is a very common compile-time error in Excel VBA. It implies that a Next statement must always have a preceding For statement that matches. If a Next statement is used without a corresponding For statement, this error is generated. Let us look at
In this article we will see how you can search for a string in a PDF file and highlight it using Excel VBA. We will look at two examples, one that works with Acrobat Reader and a second that should be used if you have
In this article, I will show you various ways to copy and paste data using Excel VBA. The paste method is one of the most commonly used methods in Excel. There are two methods for pasting data, namely “Worksheet.Paste” and “Range.PasteSpecial”. Let us start with
The Case statement is a very common and useful function used in VBA. Using the case statement, you can run one of several groups of statements, depending on the value of an expression. It is an easier way to write multiple IF-THEN-ELSE statements. In this article, we
