help with Sub Worksheet_Change(ByVal Target As Range)

Bartron · #1 (**permalink**) 05-03-07, 08:05

I don't understand how you specify Target. The description suggest that Target can be a cell or range of cells so I assume there is a way to specify what you want. All the examples I have found assume the reader understands that part. I do not.

What I want to do is recalculate when a particular row changes. Perhaps an example of a valid test to show it is working would be helpful also.

Thanks.

pootle flump · #2 (**permalink**) 05-03-07, 08:16

Moving to Excel forum - let me know if I missed something.

Bartron · #3 (**permalink**) 05-03-07, 09:42

Did I create in the wrong forum? Sorry.

Bartron · #4 (**permalink**) 05-03-07, 09:44

Attempting to re-signal need for help.

MikeTheBike · #5 (**permalink**) 05-04-07, 03:09

Hi

Target is the range object of the currently selected/active Cell/Range when the worksheet that the module is in changes.

ie

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    MsgBox Target.Address
End Sub

will display the address of the cell that has been changed, or the top left cell if it is a range of more that one cell.

Hope that makes sense.

MTB

EDIT: and MsgBox Target.Row displays the current row number.

pootle flump · #6 (**permalink**) 05-07-07, 08:26

Quote:

Originally Posted by Bartron

Did I create in the wrong forum? Sorry.

No probs

Internet Services

Web Development

Digital Marketing

Consumer Tech