Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine the column where a cell was found
Hi all, I have a find that returns the range of a cell where the search-value is found. does anyone know how i can determine the column where this cell is located? Code: -------------------- Set teamNameRng = searchRng.Find(What:=tempTeamName, _ After:=startRng, _ Lookat:=xlWhole, _ LookIn:=xlFormulas, _ SearchOrder:=xlByColumns, _ SearchDirection:=xlNext, _ MatchCase:=False) -------------------- Than a lot in advance regards thomas -- usadream ------------------------------------------------------------------------ usadream's Profile: http://www.excelforum.com/member.php...o&userid=32703 View this thread: http://www.excelforum.com/showthread...hreadid=526050 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine the column where a cell was found
Hi USADream,
Try: Dim myCol as long myCol = teamNameRng.Column --- Regards, Norman "usadream" wrote in message ... Hi all, I have a find that returns the range of a cell where the search-value is found. does anyone know how i can determine the column where this cell is located? Code: -------------------- Set teamNameRng = searchRng.Find(What:=tempTeamName, _ After:=startRng, _ Lookat:=xlWhole, _ LookIn:=xlFormulas, _ SearchOrder:=xlByColumns, _ SearchDirection:=xlNext, _ MatchCase:=False) -------------------- Than a lot in advance regards thomas -- usadream ------------------------------------------------------------------------ usadream's Profile: http://www.excelforum.com/member.php...o&userid=32703 View this thread: http://www.excelforum.com/showthread...hreadid=526050 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine the column where a cell was found
Hi, thanx a lot for your reply: now ur solution returns my the number of the column, but in the end, what i need is defining a range in this column, so for e.g. if Code: -------------------- myCol = teamNameRng.Column -------------------- -- myCol = 11 then i should be able to define a range like this: Code: -------------------- Set destrange = activeSheet.Range("myCol7 : myCol146") -------------------- where 7 and 146 are start and end rows.. does anyone know the syntax for this? help apreciated, thanx thomas -- usadream ------------------------------------------------------------------------ usadream's Profile: http://www.excelforum.com/member.php...o&userid=32703 View this thread: http://www.excelforum.com/showthread...hreadid=526050 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine the column where a cell was found
nevermind, i found it out :-) -- usadream ------------------------------------------------------------------------ usadream's Profile: http://www.excelforum.com/member.php...o&userid=32703 View this thread: http://www.excelforum.com/showthread...hreadid=526050 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use cell to determine column in formula | Excel Worksheet Functions | |||
How do I determine the last cell in a Column | Excel Discussion (Misc queries) | |||
How to determine the column letter from Cell address | Excel Worksheet Functions | |||
How can I determine the largest physical size cell in a column | Excel Worksheet Functions | |||
Determine start column/ end column of Merged Cell | Excel Programming |