I need assistance in excel to convert an old xlm macro to
vb code that will run in excel xp.. I hope to god there is
someone out there that can help me.
This is what the xlm code looks like....
S
{LET ROI,+SEED}
Q {LET ROI,+ROI+0.1}
{CALC}
{IF NPV<0}{BRANCH \Q}
{LET ROI,+ROI-0.1}
W {LET ROI,+ROI+0.01}
{CALC}
{IF NPV<0}{BRANCH \W}
{LET ROI,+ROI-0.01}
E {LET ROI,+ROI+0.001}
{CALC}
{IF NPV<0}{BRANCH \E}
{LET ROI,+ROI-0.001}
R {LET ROI,+ROI+0.0001}
{CALC}
{IF NPV<0}{BRANCH \R}
{BEEP}
Any feedback will be greatly appreciated.
Thankyou