Description The VBA UBound (Upper Bound) function returns the upper limit of an array as opposed to the LBound (Lower Bound) that returns the lower limit of an array. Both functions (UBound and LBound) can be combined to determine the size of an array. Syntax
As a VBA developer you sometimes need to use a key or a combination of keys to run a procedure without using the command button on a UserForm. This is possible with the VBA onkey method. Syntax The syntax for the OnKey method is: Application.OnKey
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
