Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using Excel 2003
I have a range of cells ("B27:R63") some of which are RGB(255, 128, 128) These cells will change every week. I have a CommandButton1_Click that needs to go through the range and find those colored cells and replace the color to none and add diagonal borders LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic Can someone please help with a Macro so I don't have to do this by hand twice a week for the next seventeen weeks? My pea brain got close a couple of times but I got frustrated and deleted the entire thing to start over. Thought I'd ask for help first. Thanks CR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding row without borders | Excel Discussion (Misc queries) | |||
Borders | Excel Programming | |||
Borders | Excel Worksheet Functions | |||
Adding new rows with borders | Excel Programming | |||
Adding Borders | Excel Worksheet Functions |