ColorIndex

Home/Tag: ColorIndex

Delete rows based on Cell Color using VBA

VBA code to vba delete rows based on cell color example will help us to delete rows based on cell background fill color from excel worksheet. We can use Delete method of Rows to delete the rows based on Cell Color. In this example we will see how to delete the rows in excel worksheet

By |April 21st, 2014|VBA|4 Comments

Delete rows based on Cell font Color using VBA

VBA code to delete rows based on Cell font Color example will help us to delete rows based on cell font color from excel worksheet. We can use Delete method of Rows to delete the rows based on Cell font Color. In this example we will see how to delete the rows in excel worksheet

By |April 21st, 2014|VBA|0 Comments

VBA Objects Properties and Methods in Excel

Most of the programming languages today are Object Based Or Object Oriented Programming Languages. Although Excel VBA is not a truly object oriented programming language, it does deal with objects.

In this topic:
  • What are Objects?
  • What are Properties?
  • What are Methods?
  • What is Object Browser?

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
This website uses cookies to ensure we give you the best experience and service. By accessing this site, you consent to the use of cookies. For more information, refer to our Privacy Policy. Got it!