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