I need a macro to run down a column A and where its value is 0 I need
to copy two columns to a new location.

----a----b----c----d
1---6---a
2---0---b
3---4---c

In this case I need to copy "6" to C1 and "a" to D1. Then copy "4" to
C2 and "c" to D2. There are up to five hundred rows.

Thanks for helping this thick headed sole.

Craig


--
Craigm
------------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=379709