Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seclect Column or Range according to Cell's Contents
I need a VBA macro to do the following
I have to search for a specific word say "Sunday" within a range (A7:AJ7). When the word is found, the column containing the cell with the word "Sunday", or a special range within the column should be shaded. Any help would be much appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seclect Column or Range according to Cell's Contents
Dim oCell As Range
With Range("A7:AJ7") Set oCell = .Find("Sunday", LookIn:=xlValues) If Not oCell Is Nothing Then oCell.EntireColumn.Select End If End With -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Nora N" <Nora wrote in message ... I need a VBA macro to do the following I have to search for a specific word say "Sunday" within a range (A7:AJ7). When the word is found, the column containing the cell with the word "Sunday", or a special range within the column should be shaded. Any help would be much appreciated |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seclect Column or Range according to Cell's Contents
Thank you Bob, However, I still need further assistance
What I actualy need is when the word "Sunday" is founded in a cell within the range A7:AJ7(Suppose H7) I want range H8:H30 to be shaded in Gray. Thank you "Nora N" wrote: I need a VBA macro to do the following I have to search for a specific word say "Sunday" within a range (A7:AJ7). When the word is found, the column containing the cell with the word "Sunday", or a special range within the column should be shaded. Any help would be much appreciated |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seclect Column or Range according to Cell's Contents
Dim oCell As Range
With Range("A7:AJ7") Set oCell = .Find("Sunday", LookIn:=xlValues) If Not oCell Is Nothing Then oCell.Offset(1,0).Resize(30 - oCell.Row).Interior.Colorindex = 15 End If End With -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Nora N" wrote in message ... Thank you Bob, However, I still need further assistance What I actualy need is when the word "Sunday" is founded in a cell within the range A7:AJ7(Suppose H7) I want range H8:H30 to be shaded in Gray. Thank you "Nora N" wrote: I need a VBA macro to do the following I have to search for a specific word say "Sunday" within a range (A7:AJ7). When the word is found, the column containing the cell with the word "Sunday", or a special range within the column should be shaded. Any help would be much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using cell's contents as an index to a row ... ? | Excel Worksheet Functions | |||
link to a cell's contents | Excel Worksheet Functions | |||
link to a cell's contents | Excel Worksheet Functions | |||
How do I make a cell's contents equal to another cell's contents with macro program? | Excel Programming | |||
Can I select a range based on the cell's contents? | Excel Programming |