| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doing search in worksheet
I need to search all worksheets to see if any cell has a formula in it? Any
help is appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Doing search in worksheet
"lostinexcel" wrote: I need to search all worksheets to see if any cell has a formula in it? Any help is appreciated. I also need to take the information found, place it in a new worksheet, name the worksheet in column A, put the formula in column B, and the formula result in column C. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Doing search in worksheet
Try this in a standard module:
Sub find_formula() Dim sh As Worksheet, cel As Range For Each sh In Sheets For Each cel In sh.UsedRange If cel.HasFormula Then MsgBox cel.Address End If Next cel Next sh End Sub -- Regards, The Code Cage Team www.thecodecage.com/forumz "lostinexcel" wrote: "lostinexcel" wrote: I need to search all worksheets to see if any cell has a formula in it? Any help is appreciated. I also need to take the information found, place it in a new worksheet, name the worksheet in column A, put the formula in column B, and the formula result in column C. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Doing search in worksheet
Using the worksheet menu
Edit - GoTo - Special - Formulas "Code Cage Team" wrote: Try this in a standard module: Sub find_formula() Dim sh As Worksheet, cel As Range For Each sh In Sheets For Each cel In sh.UsedRange If cel.HasFormula Then MsgBox cel.Address End If Next cel Next sh End Sub -- Regards, The Code Cage Team www.thecodecage.com/forumz "lostinexcel" wrote: "lostinexcel" wrote: I need to search all worksheets to see if any cell has a formula in it? Any help is appreciated. I also need to take the information found, place it in a new worksheet, name the worksheet in column A, put the formula in column B, and the formula result in column C. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search one worksheet to pull data into another worksheet | Excel Worksheet Functions | |||
| Can I search for a worksheet by Tab Name? | Excel Discussion (Misc queries) | |||
| Search one worksheet for values in another worksheet? | Excel Discussion (Misc queries) | |||
| Search for worksheet | Excel Programming | |||
| Create a search Field within a worksheet to search command buttons | Excel Programming | |||
Hybrid Mode
