You may want to explain more about when you want this code to run and how it
should be started.

cyote101 wrote:

well thank you for your help,

I actually need a code for a macro, so itcan be used onlywhen it's need
not all the time. buti think thats the trick. so howdo i make it into a
macro, this is whati have so far

================================================== ========
Sub Createpack()

Dim i As Long
Dim MacroName As String

Select Case Target.Address
Case "$s$6"
MacroName = "addmc"
Case "$r$6"
MacroName = "addjar"
Case "$q$6"
MacroName = "add2oz"
Case "$p$6"
MacroName = "add8oz"
Case "$o$6"
MacroName = "add18oz"
Case "$n$6"
MacroName = "add32oz"
Case Else

Exit Sub

--
cyote101
------------------------------------------------------------------------
cyote101's Profile: http://www.excelforum.com/member.php...o&userid=36145
View this thread: http://www.excelforum.com/showthread...hreadid=559211

--

Dave Peterson