Target value, Next cell
 

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

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

Bob:

Thank you very much. Please excuse the beginner questions.

Kind regards,

Darryl

"Bob Phillips" wrote:


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

No problem Darryl,

you can't move on without understanding, so ask away.

Bob


"D.Parker" wrote in message
...
Bob:

Thank you very much. Please excuse the beginner questions.

Kind regards,

Darryl

"Bob Phillips" wrote:


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