| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test for value then format!
Thanks to Don Guillett I found the below code and it works great. But I need
it to select more than one cell to format. Is it possible to modify the code to select several cells in the same row? Sub insertline() For Each c In Range("a2:a100") If UCase(c) = "TOTAL" Then With c.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With End If Next c End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test on the format of a cell in a formula ? | New Users to Excel | |||
| How can I test for colour format in if statements? | Excel Worksheet Functions | |||
| Can one test for Excel cell format patterns? | Excel Programming | |||
| Is there a logical test for a cell's format instead of contents | Excel Worksheet Functions | |||
| Test a file to retrieve format | Excel Programming | |||
Threaded Mode
