John Morris wrote:

Thanks for your help. That did the trick for one part of my macro but I
need to move the back to column A and that formula will not take a
negative number. Any Ideas?

AFAIK, you *can* use a negative integer. I succesfully tried giving
negative offsets.
Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.