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

Danz

On my code just change the columns ("A:A") to ("A:B").

Danz: Not aimed at you.... How much do I hate replies from these forums
mirroring the MS newsgroups? They don't show replies in a standard fashion
and never include any of the original messages. Does anyone have a channel
to the people who run these or is it just me? Maybe too it's the way MS is
handling them, but it's starting to get really annoying!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Danz" wrote in message
...

I have got the above macro set up and it is workiing great, thanks. Just
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 was
thinking it must be in the part where you specify the range). The
functin can be the same, so basically want to duplicate the macro to
run in 2 coloumns on the same sheet, thanks again in advance.


--
Danz
------------------------------------------------------------------------
Danz's Profile:
http://www.excelforum.com/member.php...o&userid=16448
View this thread: http://www.excelforum.com/showthread...hreadid=278087