Learn Excel VBA by Examples, it is easy to follow the codes and learn Excel VBA from our examples codes.

Inserting Columns in Excel Worksheet using VBA

Description: When we are automating any task we may required inserting columns between other columns or left/right side of a column using Excel VBA. For example, we may generate employee performance report based on their tenure in an organization. The first column would be 'Employee ID' and the last column would be 'Tenure (in months)'.

Inserting Rows in Excel Worksheet using VBA

VBA insert rows excel macro helps while automating and dealing with the records. For example, we may automate certain task based on the number of items in certain category. And the number of items may not be equal in all the situations it may vary time to time. We will see a practical example in

Hide UnHide Rows in Excel Worksheet using VBA

Description: We are required to Hide-UnHide the rows in some types of requirements. For examples we may have data for 3 different categories of items and we may want to show the respective items based on selection. In this case we can achieve by Hiding or Un-hiding the Rows. We will see this in the

Select Cell Range in Excel VBA

We select cell range in Excel VBA to do particular task with the selection. For example we may want to change the background color of a range and we may want to change the font to Bold. In this case we do not required to loop each and every cell of the range to change the background color and font.

By |February 15th, 2013|Excel VBA|12 Comments

Change Background Color of Cell Range in Excel VBA

Description: It is an interesting feature in excel, we can change background color of Cell, Range in Excel VBA. Specially, while preparing reports or dashboards, we change the backgrounds to make it clean and get the professional look to our projects. Change Background Color of Cell Range in Excel VBA - Solution(s): We can use

By |February 9th, 2013|Excel VBA|3 Comments

Find Last Column with data in Worksheet using Excel VBA

Example to show you how to find last used column with data in a Excel worksheet using VBA . It helps if you want to loop through all columns of a worksheet. We need to find last Column with data in a Worksheet Sheet if we want to loop through all columns of the worksheet using Excel VBA. For examples, my data changes every time but I need to perform same task for each column. In this situation I need to know the last column of the data every time the perform the task.

By |February 8th, 2013|Excel VBA|1 Comment