The ListObjects property of the Worksheet object returns the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet. The ListObject object is a member of the ListObjects collection. Each ListObject object represents a table (previously known as a list) in the worksheet. An
Many times as a developer you might need to find a match to a particular value in a range or sheet, and this is often done using a loop. However, VBA provides a much more efficient way of accomplishing this using the Find method. In
In this article, we will see how to update records in Access database through Excel VBA using ActiveX Data Objects (ADO). Let’s say you have a database named “Products”. In that database, there is a table “ProductTable” that contains the product details of your business
This article shows how to use VBA in MS Word to delete empty rows from a table or rows that have at least one cell that is empty. Say you have multiple tables in a Word document and you want to print the document with
Creating a PowerPoint presentation using data from Excel is very common. You can simply create a new PowerPoint, copy all the data, and you’re done. But consider a periodic report — a sales report, for example. Each month you need to create a PPT with data in
In this article I will explain the function Get_Count(). Get_Count() is a function which I have written myself. The main purpose of this function is to return the number of rows or columns of data starting from a specific cell. It is very useful when
One of the main tasks an Excel VBA programmer encounters is searching excel sheets for a specific value. While there are many different methods for doing a search, in this article I will only cover the basic method of using a For Next loop. In
In this article I will explain how to retrieve data from a website using a query table and VBA. Previously in the article Excel Getting Data From the Web I’ve explained how you can use Query Tables to import data from the web into an excel worksheet.
In this article I will explain how to work with the Range and Cell objects. While the terms range and cells may be used interchangeably, they are two different objects, and have different functions and properties. There are two main notations for referencing ranges: Range(“A1:B1”) notation Range( Cells(1,
When you are working with strings, string processing and manipulation is an important tool. Whether you want to search for a certain expression in a string, split a string, add multiple strings … you will have to be familiar with the concepts of string processing.