Please review the attached code. The goal seek formula is making the adjustment in cell E64. I need to set up a limit in which the amount in E64 that goal seek recommends should not be less than 0 or greater than the amount in cell I64. If the amount does not fall within this parameter an error message appears stating "Amount Does Not Fall Within Required Parameters. Please Try Again".
Any suggestions on how to make this happen?
Range("E74").GoalSeek Goal:=Range("H68"), ChangingCell:=Range("E64")