Re: $$Excel-Macros$$ How to keep variables constant in a procedure

2015-11-06 Thread Victor Wang
quot;. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you

Re: $$Excel-Macros$$ How to keep variables constant in a procedure

2015-11-06 Thread Paul Schreiner
John Wesley - From: Victor Wang To: MS EXCEL AND VBA MACROS Sent: Thursday, November 5, 2015 10:19 PM Subject: $$Excel-Macros$$ How to keep variables constant in a procedure Below are some simple codes.  At the beginning there are values i

$$Excel-Macros$$ How to keep variables constant in a procedure

2015-11-05 Thread Victor Wang
Below are some simple codes. At the beginning there are values in Cell "Num_Buy" and "Num_Sell". Let's say 4 and 3 respectively. I want to do one thing for "Num_Buy" times and the other things for "Num_Sell" times by using the two loops. The problem is that as the first loop runs, the "