Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find string and format 54 columns to right
Hi All
I'm trying to write code that looks in column A and finds the word "total" (which has words before or after it in the same cell, plus could be in upper or lower case). Whenever "total" is found I need it and the 56 columns to it's right selected and formatted with the following: With Selection .Font.FontStyle = "Bold" .Font.ColorIndex = 2 .Interior.ColorIndex = 47 End With I tried this code, but it won't pick up the "string" in a cell and I don't know how to change the code so it does that: Columns("A:A").Select For Each oCell In ActiveSheet.UsedRange If oCell = "*Total*" Then Range(oCell.Offset(1, 0), oCell.Offset(0, 54)).Select With Selection .Font.FontStyle = "Bold" .Font.ColorIndex = 2 .Interior.ColorIndex = 47 End With End If Next oCell Any help would be greatly appreciated. -- Thank for your help BeSmart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find String in another string - only between spaces | Excel Worksheet Functions | |||
Find Many String options in ONE String | Excel Worksheet Functions | |||
Q: find range, listbox - format and fit columns | Excel Programming | |||
backwards find function to find character in a string of text | Excel Programming | |||
find a string inside another string | Excel Programming |