I have got the above macro set up and it is workiing great, thanks. Jus
one more question, if i want to run this macro on 2 different coloumns
for eg coloumn A and B) what would i have to change in the code? (i wa
thinking it must be in the part where you specify the range). Th
functin can be the same, so basically want to duplicate the macro t
run in 2 coloumns on the same sheet, thanks again in advance

--
Dan
-----------------------------------------------------------------------
Danz's Profile: http://www.excelforum.com/member.php...fo&userid=1644
View this thread: http://www.excelforum.com/showthread.php?threadid=27808