Target value, Next cell

D

D.Parker

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
 
B

Bob Phillips

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

--

HTH

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

D.Parker

Bob:

Thank you very much. Please excuse the beginner questions.

Kind regards,

Darryl
 
B

Bob Phillips

No problem Darryl,

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

Bob
 
Top