Hi,

I'm looking to run a macro that references another Sheet.

If the Name, say, DAN shows up in cell C8 and the CELL color = 41
then activesheet.range(a1) colorindex = 41

if the name DAN shows up in cell C8 and the CELL color = 6
then activesheet.range(a1) colorindex = 6

and so on and so on.

But I'll be damned if I cant figure it out. I'm working on it as
side project for my boss... If anyone can help me out, that'd b
great.

-jlarkin

--
jlarki
-----------------------------------------------------------------------
jlarkin's Profile: http://www.excelforum.com/member.php...nfo&userid=865
View this thread: http://www.excelforum.com/showthread.php?threadid=27244