Target value, Next cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Bob:

Thank you very much. Please excuse the beginner questions.

Kind regards,

Darryl
 
No problem Darryl,

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

Bob
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel VBA 1
copy rows to multiple sheets 1
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
Hide/Unhide worksheets upon entries in a range of the main worksheet 5
Numbers change in cell even when formatted as text 4
Highlighting row of active cell question 4

Back
Top