Target.Offset(0,1).Value = "whatever"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"D.Parker" wrote in message
...
Hello again. I'm in my worksheet object ,and if the contents of the
target
cell have a specific value then I would like the cell to the right of the
target cell to update with new information. This will happen for multiple
rows. Is there a way to do this in the worksheet object without
individual
line code for each row?

Kind regards,

D.Parker