 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007How do I find all cells with formulas
How do I find all cells with formulas, Excel 2003. Thanks in advance.  SignaturePeggy Duncan, Author Conquer Email Overload with Outlook http://www.PeggyDuncan.com You might try looking in the vba help index for HASFORMULA and build a looping macro for each c in range("yours") if c.hasformula next SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > How do I find all cells with formulas, Excel 2003. Thanks in advance. One way... Select the range to search (all the cells on the worksheet???) Edit|goto|special|check Formulas And the selection will change to just those cells with formulas. > How do I find all cells with formulas, Excel 2003. Thanks in advance. > -- > Peggy Duncan, Author > Conquer Email Overload with Outlook > http://www.PeggyDuncan.com SignatureDave Peterson Duh!! Way too easy<g> Gord >One way... >Select the range to search (all the cells on the worksheet???) [quoted text clipped - 7 lines] >> Conquer Email Overload with Outlook >> http://www.PeggyDuncan.com Depends on what you want to do with the cells after you find them. There's always lots of options! > Duh!! > [quoted text clipped - 13 lines] > >> Conquer Email Overload with Outlook > >> http://www.PeggyDuncan.com SignatureDave Peterson I never even thought of the Goto>Special. Why does Excel hide all those neat tricks from guys like me with short memories? >Depends on what you want to do with the cells after you find them. > [quoted text clipped - 17 lines] >> >> Conquer Email Overload with Outlook >> >> http://www.PeggyDuncan.com I once suggested using shortcut keys for something. Myrna Larson wrote a followup that going through the menus is a good way to see what MS hid under the menus. It makes sense to me still. (I can't wait for xl2007 <bg>.) > I never even thought of the Goto>Special. > [quoted text clipped - 21 lines] > >> >> Conquer Email Overload with Outlook > >> >> http://www.PeggyDuncan.com SignatureDave Peterson One method. View>View Formulas and visually look for them. Another method using a macro which colors all cells with formulas in all worksheets. Sub Formulas() Dim rng As Range Dim fcell As Range Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets Set rng = wks.UsedRange For Each fcell In rng If fcell.HasFormula Then fcell.Interior.ColorIndex = 6 'yellow End If Next fcell Next wks End Sub Gord Dibben MS Excel MVP >How do I find all cells with formulas, Excel 2003. Thanks in advance.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.