I need to run a macro from a button which will copy the contents of cell F16
ONLY if it is text rather than a formula. (Basically the default value of the
cell is a formula but the user can overwrite the formula if required - if
they do this I then need to copy their input to another cell.) The
destination cell is also dependent upon the value in cell F4.

I can't seem to get anywhere at all with this - if anyone can help would be
very much appreciated!

Thanks

Phil