Hi Try:
Sub Mtest() Dim found As Range Dim m As String, Temp As String Dim count As Integer Dim ws As Worksheet count = 0 m = InputBox(prompt:="Enter value for search", Title:="Excel Find") For Each ws In ActiveWorkbook.Worksheets Set found = ws.Cells.Find(What:=m, LookIn:=xlValues, lookat:=xlPart) If Not found Is Nothing Then count = count + 1 MsgBox found.Worksheet.Name & found.Cells.Address, Title:="Excel Find" found.Cells.Interior.ColorIndex = 6 Temp = MsgBox(prompt:="Clear highlighting", Title:="Excel Find", Buttons:=vbOKCancel + vbQuestion) If Temp = vbOK Then found.Cells.Interior.ColorIndex = xlNone End If Next ws If count = 0 Then MsgBox prompt:="Not found", Title:="Excel Find" End Sub HTH Mahesh On Sat, Oct 8, 2011 at 12:41 PM, B.N.Chethan kumar < chetankumar1...@gmail.com> wrote: > Hi, > > you give a name to cell...by using name manager,,,,and later need u call > name to . > > i have attached sample file for easy understanding > > Regards > Chethan Kumar BN > > On Fri, Oct 7, 2011 at 7:36 PM, satish > <narbhaviwithsatishku...@gmail.com>wrote: > >> Dear all, >> >> Sometimes I work with large data, if i want to find some data, >> normally I type the key word in find option, I want to highlight the >> cell with some colour to view it clearly, which cell is highlighted. >> Normally it goes to cell but i have some problem ( eye sight). >> >> Thanks in advance >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> > > > > -- > B.N Chetan kumar > > -- > > ---------------------------------------------------------------------------------- > 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