Text is a read only property

Also, you cleverly left out any explanation of how to use the value of
Target to determine the appropriate cell in Info. I will assume it is a
named range.

If Not Intersect(Target, Range("A14:A35")) Is Nothing Then
Range("C" & Target.Row).Value = sheets("Info").Range(Target.Value).Text
end if

Note several changes to your original code.

--
Regards,
Tom Ogilvy


"Max C" wrote in message
ups.com...
OK, the subject should say a lot about my Excel programming experience.
I'm quite the flaming novice. :)

I'm trying to change the text in a sheet named "Cert" on a cell
starting in column C to the text in a cell in another sheet in the same
workbook named "Info" when the cells in the A column change. I was
thinking this should be really easy and doable in 2 or 3 lines.

Here's what I came up with:

If Not Intersect(Target, Range("A14:A35")) Is Nothing Then
Range("C:" & Target.Row).Text = sheets("Info") ... and then the
cell, based on target cell's value.

It's the part after the "=" that I think is really getting me. It
can't be that hard... but I'm managing to make it so. Any advice would
be greatly appreciated.

Max.