Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula vs data
I am creating a scheduling program whereby the user has the ability to
override the formula automatically created through my VB with a fixed date. What I need is to move through the cells and determine which ones are actual formulas vs which ones are fixed data. Does anybody have the code necessary to determine whether a cell contains a formula or a fixed date? -- M. Shipp |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula vs data
Look in VBA Help under HasFormula.
-- Vasant "SHIPP" wrote in message ... I am creating a scheduling program whereby the user has the ability to override the formula automatically created through my VB with a fixed date. What I need is to move through the cells and determine which ones are actual formulas vs which ones are fixed data. Does anybody have the code necessary to determine whether a cell contains a formula or a fixed date? -- M. Shipp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
received "a=formula" instead of =formula after exporting data - wh | Excel Worksheet Functions | |||
Formula to sum data from a data range | Excel Discussion (Misc queries) | |||
Formula to capture historical data from data that changes daily | Excel Discussion (Misc queries) | |||
Formula to capture historical data from data that changes daily | Excel Worksheet Functions | |||
Any cell containing formula seen as data instead of formula | Excel Worksheet Functions |