Hi there

I have a sheet that processes a macro upon a worksheet change event. When a cell is changed on one sheet, a picture of a persons signature (jpg) is inserted on another sheet. I can specify the cell that I want the jpg to appear easily enough, however I want the function to search for some text "Yours Sincerely" and insert the picture at that cell. The problem comes in that the "Yours Sincerely" appears as part of a formula (it is based on an 'If' formula), so when I search for it, it can't find it. So I need it to find the value of the cell. Any ideas anyone?

Thanks

Neil