Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how tell if cell has formula
Thanks for any help.
I have a workbook with six tabs that are all formula. But sometimes I paste values over these formulas by mistake. I would like somehow to check quickly if the cells are formulas, or values. I could do this by selecting the cells one by one, and looking at the formula bar. But there are about 200-300 cells, so this would take a couple minutes or so per tab. I could also write some code I think that checks each cell to see if it has a formula or not, and tell the user so. But preferably I think, I would like some worksheet function that could do this. Maybe have it check over a range. Are there any functions that can tell if a cell has a formula or is just a value? I looked at the CELL worksheet function, but it doesn't look like it can tell. Thanks very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel |