Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using find range
Dim rng as Range
Dim rngCol as Long Set rng = Range("2:2").Find(what:="Number", LookIn:=xlValues, _ lookat:=xlWhole, searchorder:=xlByColumns, MatchCase:=True) If Not rng Is Nothing Then rngcol = rng.Column Rows("4").Columns("A" & rngcol).Interior.Color = RGB(221, 221, 221) End if I am not sure what you want to color. The above would color the cell in the 4th row of the found column. if you want to do the entire column Columns(rngCol).Interior.Color = RGB(221,221,221) -- Regards, Tom Ogilvy "Dan" wrote in message ... With this piece of code, I'm wondering how to reference the resulting column from the find information in the rows.columns bit below that, normally I would just do .Columns("A:AN") or something similar, but I'm not sure how to replace "AN" with a variable, rngcol. I'm also not sure what to dim rng and rngcol as. Thanks for any help. Set rng = Range("2:2").Find(what:="Number", LookIn:=xlValues, _ lookat:=xlWhole, searchorder:=xlByColumns, MatchCase:=True) If Not rng Is Nothing Then rngcol = rng.Column Rows("4").Columns("A:rngcol").Interior.Color = RGB(221, 221, 221) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using find range
Let me correct that
Rows("4").Columns("A" & rngcol).Interior.Color = RGB(221, 221, 221) would be column A, rngcol - 1 rows below 4, which probably isn't what you want. So, I suspect you want to do the cell on row 4 at the rngcol location. That would be Cells(4,rngcol).Interior.Color = RGB(221, 221, 221) -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Dim rng as Range Dim rngCol as Long Set rng = Range("2:2").Find(what:="Number", LookIn:=xlValues, _ lookat:=xlWhole, searchorder:=xlByColumns, MatchCase:=True) If Not rng Is Nothing Then rngcol = rng.Column Rows("4").Columns("A" & rngcol).Interior.Color = RGB(221, 221, 221) End if I am not sure what you want to color. The above would color the cell in the 4th row of the found column. if you want to do the entire column Columns(rngCol).Interior.Color = RGB(221,221,221) -- Regards, Tom Ogilvy "Dan" wrote in message ... With this piece of code, I'm wondering how to reference the resulting column from the find information in the rows.columns bit below that, normally I would just do .Columns("A:AN") or something similar, but I'm not sure how to replace "AN" with a variable, rngcol. I'm also not sure what to dim rng and rngcol as. Thanks for any help. Set rng = Range("2:2").Find(what:="Number", LookIn:=xlValues, _ lookat:=xlWhole, searchorder:=xlByColumns, MatchCase:=True) If Not rng Is Nothing Then rngcol = rng.Column Rows("4").Columns("A:rngcol").Interior.Color = RGB(221, 221, 221) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using find range
Thanks for the help. What I am looking to color, is the entire row, columns A through whatever column rngcol is.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using find range
Range("A4").Resize(1, rngcol).Interior.Color = RGB(221, 221, 221)
-- Regards, Tom Ogilvy "Dan" wrote in message ... Thanks for the help. What I am looking to color, is the entire row, columns A through whatever column rngcol is. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
Find the MAX number in range, then find... | Excel Discussion (Misc queries) | |||
Find a range of values in a range of cells | Excel Worksheet Functions | |||
Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming |