I would set it up with three separate loops, not knowing if there are as many
items in the other columns as in D.


I also have to admit that it is easier to replicate the code than to re-work
it into a more general form. (a good programmer would create a sub and call
it three times)
--
Gary's Student


"Hru48" wrote:


Ok got it thanks!

One more thing though, I have three blocks of these to do - is there
anyway I can write them all into one sub?

say this one start on d8 and the next one would be g8 next i8?


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=541576