Thank you all for the solutions provided.

Would it possible to locate the cell that has been used in the formula
and highlight that cell? Eg:

=Sum(A4,a7,a9), when we run the macro, A4,A7,A9 should get highlighted

Harry

On Apr 26, 10:28 am, rf1234 rf1234 <rfhyd1...@gmail.com> wrote:
> Hello Dear,
> Attached Workbook have a solution,Regarding your Problem.
>
> Hope It Will Help
>
> On Sat, Apr 24, 2010 at 10:43 PM, Harpreet Singh Gujral
>
>
>
>
>
> <harpreetguj...@gmail.com> wrote:
>
> > Hi Group,
>
> > I have a weird query today, i hope i am able to present the case and a
> > solution is possible for it.
>
> > I need to achieve the following:
>
> > 1) A macro that will search the whole sheet for those cells which consists
> > of formulas
>
> > 2) And if a cell is found meeting criteria one, It needs to be able to find
> > out the cell address, that is referred to in the formula
>
> > Is it possible, or i am just day dreaming!!!!
>
> > Another question, can search all the cells on the worksheet, with a
> > crietria. Example: Cells which have input as "XXYYYYY" are only identified
> > in a loop.Where XX are alphabets and YYYYY is numeric.
>
> > Any suggestions
>
> > Harry
>
> > --
> > ---------------------------------------------------------------------------­-------
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,800 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
> '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''­'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''­''''''''''''''''''''''''''''''''''''''''''''''''
> When one door of happiness closes, another opens;
>  but often we look so long at the closed door that we do not see the
>  one which has been opened for us.
> - Helen Keller
> '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''­'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''­''''''''''''''''''''''''''''''''''''''''''''''''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
>  dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
> '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''­'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''­''''''''''''''''''''''''''''''''''''''''''''''''
>
> --
> ---------------------------------------------------------------------------­-------
> 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 athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe
>
>  Read Range Formula,numeric,string.xls
> 61KViewDownload- Hide quoted text -
>
> - Show quoted text -

-- 
----------------------------------------------------------------------------------
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Reply via email to