There might be better ways of accomplishing the same thing without using
sendkeys.

If you post a few examples of what's in those cells (and what should be
deleted), it might be easier to follow.

(and you want a hyperlink when you're done, too? mailto://, I bet???)

tim64 wrote:

I have a list of names I'm using this on and I want it to do that
process until there is nothing in the selected box (it's sopose to go
down one each loop)

--
tim64
------------------------------------------------------------------------
tim64's Profile: http://www.excelforum.com/member.php...o&userid=23295
View this thread: http://www.excelforum.com/showthread...hreadid=380569

--

Dave Peterson