[ExcelVBA] Re: VBA for Finding value in Current Cell

 

Charlie,

Try

Sub FindIt

Cells.Find(What:=ActiveCell.Value, After:=Range("H1"), LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=True, SearchFormat:=False).Activate
End Sub

Dave Gathmann

--- In ExcelVBA@yahoogroups.com, railroads@... wrote:
>
> Hi
>
> Just athe basics.
>
> I want to find the value in current cell in another column say H column.
> Say value in A1(current cell) is: Tom
>
> i.e. Want to locate Tom in column H
>
> I should no the answer but have lost it in my files. (probably should read 'have lost the plot')
>
> Thanks
>
>
> Charlie Harris
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 13

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___