| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to find all formulas in a workbook
Anyone have a macro that highlights all the formulas in a workbook and shades
the cell a given color? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to find all formulas in a workbook
For the active sheet in yellow:
Sub dave() Set r = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormu las) r.Interior.ColorIndex = 6 End Sub -- Gary''s Student gsnu200711 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to find all formulas in a workbook
click F5 Special select Formulas Ok select any color you want Enter
"Dave F" wrote: Anyone have a macro that highlights all the formulas in a workbook and shades the cell a given color? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run macro to find names on seperate workbook, then add info from t | Excel Discussion (Misc queries) | |||
| find and replace within workbook macro | Excel Discussion (Misc queries) | |||
| Runing a macro in a workbook from another macro in other workbook | Excel Discussion (Misc queries) | |||
| Find Macro across workbook | Excel Worksheet Functions | |||
| How to Find Workbook with Macro | Excel Discussion (Misc queries) | |||
Linear Mode
