I think this is much simple.
after you find the cell write below stement.
a = ActiveCell.Address
if you wanna use that cell u can use like below example.
Range(a).Offset(1, 3).Select
>
>From: ashish koul <koul.ash...@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Mon, 24 January, 2011 8:40:37 PM
>Subject: Re: $$Excel-Macros$$ How to get the address of a cell in VBA
>
>
>check the attachement
>
>Sub ABC()
>Dim I, J, K As Long
>Dim foundcell As Range
> Set foundcell = Sheets(1).Range("a1")
> Set foundcell = Sheets(1).Columns(1).Find(What:=10, After:=foundcell, _
> LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _
> SearchDirection:=xlNext, MatchCase:=False)
>If foundcell Is Nothing Then
>Else
>
>' one way
>foundcell.Interior.Color = vbRed
>' 2nd way
>Range("b1").Value = Range(foundcell.Address).Value + 20
>' 3 rd way
> Cells(1, 3).Value = Cells(foundcell.Row, foundcell.Column).Value + 30
>foundcell.Offset(0, 4) = foundcell
>
>End If
>
>End Sub
>
>
>
>On Sat, Jan 22, 2011 at 3:26 AM, Mao <yanjiemao...@gmail.com> wrote:
>
>Hi there,
>>
>>I have a question about how to locate the address of the cell in VBA
>>
>>For example, I am looking for "ABC" in my sheet. By using FIND
>>function, I got the location as A1.
>>
>>How could I write this location into one variable? So when later I am
>>using ABC again, I could refer Range("A1") directly.
>>
>>
>>Thanks
>>
>>Mao
>>
>>
>>--
>>----------------------------------------------------------------------------------
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links :
>>http://twitter.com/exceldailytip
>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>><><><><><><><><><><><><><><><><><><><><><><>
>>Like our page on facebook , Just follow below link
>>http://www.facebook.com/discussexcel
>>
>
>
>--
>
>Regards
>
>Ashish Koul
>akoul.blogspot.com
>akoul.wordpress.com
>My Linkedin Profile
>
>
>PBefore printing, think about the environment.
>
--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
