Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell colour change
could some one please tell me how in a visual basic macro i can change the
background colour of a cell. |
#2
|
|||
|
|||
activecell.interior.colorindex = 3
sets it to red -- HTH Bob Phillips "anthony" wrote in message ... could some one please tell me how in a visual basic macro i can change the background colour of a cell. |
#3
|
|||
|
|||
Hi Anthony,
You can try: ActiveCell.Interior.ColorIndex = x where x is the colour reference (6 is yellow) Hope this helps Warm regards Sunil Jayakumar "anthony" wrote in message ... could some one please tell me how in a visual basic macro i can change the background colour of a cell. www.ayyoo.com/credit-cards.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |