kixelsid,

Sorry for not getting back to you sooner.

Here is what you can do (using the code I provided as an example):



Sub MasterMacro() 'Or you can give it a more meaningful name than "MasterMacro"
IfThenElseLoop 'If you changed the name of it, use that instead of "IfThenElseLoop"
IfThenElseLoop2 'Or whatever name you gave them when you copied them.
IfThenElseLoop3
IfThenElseLoop4
End Sub



Hopefully that will work for you. Let me know.

Conan


"kixelsid" wrote in message
...

Conan,

1 more question if i may. Your script worked perfect all i had to do
was copy/paste & rename it several times for each cell. Now, my
question is since these are subs, can I make 1 macro that runs all the
macros at once?


--
kixelsid
------------------------------------------------------------------------
kixelsid's Profile: http://www.excelforum.com/member.php...o&userid=31901
View this thread: http://www.excelforum.com/showthread...hreadid=516301