Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]() 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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |