First off, this is my first post on this site and i'm excited. I've use
another site for years and recently i thought of looking at other sites
and talk about a sign or something; after registering the first topic
saw was the exact topic i was working on! WOW --- I think i've come t
the right place!!!!!!!!!!

so here we go


how would i adapt this code
================================================== ==========
If [s6].Value = 1 Then Call addMC
If [r6].Value = 1 Then Call addJar
If [q6].Value = 1 Then Call add2oz
If [p6].Value = 1 Then Call add8oz
If [o6].Value = 1 Then Call add18oz
If [n6].Value = 1 Then Call add32oz
================================================== =========

so that the macros that are called are run as many times as the valu
in their respective cells.

Example: for the first line "If [s6].Value = 1 Then Call addMC" if cel
S6 = 12 then the Macro AddMC will be run 12 times and if cell S6 =
then the macro would only me run twice or even if S6 = 0 then the macr
would not be run. I think i've made my point. As you can see there i
more then 2 or so seperate macros their respective cells to run ever
time this sub is run. Thanks
Edit/Delete Messag

--
cyote10
-----------------------------------------------------------------------
cyote101's Profile: http://www.excelforum.com/member.php...fo&userid=3614
View this thread: http://www.excelforum.com/showthread.php?threadid=55921