You can create a userdefined function that returns true or false if the cell
contains a formula:
Option Explicit
Function HasFormula(rng As Range) As Boolean
Set rng = rng.Cells(1)
HasFormula = rng.HasFormula
End Function
Then you can include that test in your formula:
=hasformula(a1)
But if you start entering 5 as =5, then this won't work. It actually looks for
any old formula.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Roz wrote:
Thanks, but unfortunately, I might need that fancy/smancy function.
Sometimes the shipment comes in 6 different orders; ie a sum of 20
ordered parts comes in 5, then 4, then 3, then 5 more, etc. Do you
know of any way to modify my original equation? Thanks.
--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=494894
--
Dave Peterson