Add Data to Table Using VBA
We can use Excel VBA to insert rows and columns into an Excel table and add data to the table. In this tutorial,…
Author: Christopher Sirali
Using Iterative Calculations in Excel
The iterative or looping calculation is the repeated calculation of a worksheet using previous results until a specified numeric condition is met. It…
Change the Resolution of Microsoft Excel
We insert pictures in Excel to associate them with certain pieces of information or simply to make our worksheets more visually appealing. We…
Change Character Separating Thousands or Decimals in Excel
In many countries such as the USA, UK, and Australia, a comma (,) is used for separating groups of thousands, and a period…
Excel VBA Clear Clipboard
When we use a macro to copy and paste data in Excel, it is good practice to clear the clipboard after the operation….
Check If A File Is Open or Closed in Excel
When writing code in Excel VBA it is a good practice to first check for some conditions before taking certain actions. For example,…
Find Special Characters in Excel
Sometimes when we import data into Excel from an external data source such as a text file, it comes with special characters such…
Last Cell Address in Excel
Sometimes when we work with a large named data range, we may need to find out the address of the last cell in…
Add Data to an Existing Chart in Excel
Sometimes, after we have created a chart in Excel, we may get new data in form of rows or columns of numbers that…
Average Positive or Negative Numbers in Excel
The Excel AVERAGE function returns the average (arithmetic mean) of its arguments. Sometimes we may want to find out the average of only…
