Hi

I wish to automate a formula that I have for removing duplicate
telephone numbers.

When recording a macro, I want to paste the formula as far down as the
last number (the quantity of numbers to deduplicate will usually be
different each time ) which is situated in the previous column.

Is there a way that I can achieve this, rather than having to paste
down the whole column?

Many Thanks


--
basildon
------------------------------------------------------------------------
basildon's Profile: http://www.excelforum.com/member.php...o&userid=29700
View this thread: http://www.excelforum.com/showthread...hreadid=494135