Re: $$Excel-Macros$$ Finding cell address of a formula referred to in a cell
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 XXY are only identified in a loop.Where XX are alphabets and Y 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
$$Excel-Macros$$ Finding cell address of a formula referred to in a cell
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 XXY are only identified in a loop.Where XX are alphabets and Y 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 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
Re: $$Excel-Macros$$ Finding cell address of a formula referred to in a cell
check this Sub checkforformula() Dim i As Long Dim cell As Range For Each cell In Cells.SpecialCells(xlCellTypeFormulas) MsgBox cell.Address Next cell End Sub Sub ab() Dim i As Long Dim cell As Range 'ActiveSheet.UsedRange.Select Cells.Select For Each cell In Selection If Len(cell.Text) = 7 Then If IsNumeric(Right(cell.Value, 5)) And Application.WorksheetFunction.IsText(Left(cell.Value, 2)) Then MsgBox cell.Address End If End If Next cell End Sub 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 XXY are only identified in a loop.Where XX are alphabets and Y 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 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 -- -- 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