Very clear answer


Quote Originally Posted by Dave Peterson View Post
Start recording a macro and then quit recording.

Then you'll have the shell of the macro.

You can use tools|macros|macro
select your "dummy" macro and click the Edit button.

Paste Bob's code after this line:

Sub Macro1()

but before the "end sub" line.

Then back to excel.

select the worksheet you want and
tools|macro|macros
select that macro
and click run.

====

But you'll want to make sure that this line is correct:

If cell.Interior.ColorIndex = 10 Then

Select a cell with the color green background you like.
then back to the VBE (alt-f11)
hit ctrl-g (to see the immediate window)

Type this and hit enter:
?activecell.Interior.ColorIndex

You'll see a number. If it's 10, you're done. If it's not, you'll have to use
that number in that line of code.



JamieMorien wrote:
>
> I am an ignoramus. How do I implement this code? I normally just start
> and stop a macro recording and then paste the code in. Doesn't seem to
> work. What steps need to lead up to inserting this text? Thanks
>
> --
> JamieMorien
> ------------------------------------------------------------------------
> JamieMorien's Profile: http://www.excelforum.com/member.php...o&userid=19499
> View this thread: http://www.excelforum.com/showthread...hreadid=398943

--

Dave Peterson