determine the column where a cell was found

[usadream]

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?

Please Login or Register  to view this content.

Than a lot in advance
regards
thomas

[Norman Jones]

Hi USADream,

Try:

Dim myCol as long

myCol = teamNameRng.Column


---
Regards,
Norman



"usadream" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[usadream]

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

Please Login or Register  to view this content.

--> myCol = 11

then i should be able to define a range like this:

Please Login or Register  to view this content.

where 7 and 146 are start and end rows..

does anyone know the syntax for this?

help apreciated, thanx
thomas

[usadream]

nevermind, i found it out :-)