Hi everyone,

This is only my second post and i could really do with your help:

How do I get VB to go to a specific word within a column; then search within a predefined number of cells around itself to find the character '@'.

EG: The word 'Distance' is first found in A2 (including multiple places randomly down column A). The email address '[email protected]' could be anywhere within the range A2:B6. Once the email address is found I need VB to replace the cell containing 'distance' with the cell containing the email address. The process repeats for every cell containing 'distance' with the same predefined range (2 columns wide, 5 rows deep)

any help would be great. I would have tried to present some coding of my own but I have no Idea how it might look.

Cheers.

Tom