Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find cell in particular column
i have the same string(or number) in all the columns.
I want to find and activate the string or number in a particular column for e.g only in column B. ideas please |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find cell in particular column
Dim rng as Range, rng1 as Range
Dim fAddr as String with columns(2).Cells set rng = .find("number") if not rng is nothing then fAddr = rng1.Address Do if rng1 is nothing then set rng1 = rng else set rng1 = union(rng1,rng) end if set rng = .FindNext(rng) Loop until rng.Address = fAddr End with if nt rng1 is nothing then rng1.Select End if -- Regards, Tom Ogilvy "R.VENKATARAMAN" wrote in message ... i have the same string(or number) in all the columns. I want to find and activate the string or number in a particular column for e.g only in column B. ideas please |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
find cell in particular column
than you very much. shall use the sub
Tom Ogilvy wrote in message ... Dim rng as Range, rng1 as Range Dim fAddr as String with columns(2).Cells set rng = .find("number") if not rng is nothing then fAddr = rng1.Address Do if rng1 is nothing then set rng1 = rng else set rng1 = union(rng1,rng) end if set rng = .FindNext(rng) Loop until rng.Address = fAddr End with if nt rng1 is nothing then rng1.Select End if -- Regards, Tom Ogilvy "R.VENKATARAMAN" wrote in message ... i have the same string(or number) in all the columns. I want to find and activate the string or number in a particular column for e.g only in column B. ideas please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
Find max value in one column and return the value of corrosponding cell in different column | Excel Worksheet Functions | |||
find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Move Cell in Column A to Column B when FIND | Excel Programming |