Formula vs data

S

SHIPP

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Synchronization problems while moving folders to new email 1
Page numbering with Merged Document and IF statements 1
Calculate if 2 times differ by 24 hours? 8
cell formula question 4
Determining if Cell has Formula 3
Insert Formula based in cell user clicks 2
Employee Schedule not plotting properly - chart type / data series not correct 0

Top