Need to determine the ROW of the TARGET in a Worksheet Change Even

[Barb Reinhardt]

How do I determine what row number the TARGET is located in for a
WORKSHEET_Change event. My target MUST be one cell or this piece of the
code won't work.

Can someone assist?

Thanks,
Barb Reinhardt

[Don Guillett]

how about
if target.address="$A$1" then

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Barb Reinhardt" <BarbReinhardt@discussions.microsoft.com> wrote in message
news:0945555D-AAF9-45DD-B6E6-EA289924CC41@microsoft.com...
> How do I determine what row number the TARGET is located in for a
> WORKSHEET_Change event. My target MUST be one cell or this piece of the
> code won't work.
>
> Can someone assist?
>
> Thanks,
> Barb Reinhardt

[Barb Reinhardt]

I'm not sure I made myself clear. I could change a cell anywhere between
D13 and D100 (for example) and I want to know what row # the cell was in.
If I change D20, I want 20 returned. How do I do that?

"Don Guillett" wrote:

> how about
> if target.address="$A$1" then
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "Barb Reinhardt" <BarbReinhardt@discussions.microsoft.com> wrote in message
> news:0945555D-AAF9-45DD-B6E6-EA289924CC41@microsoft.com...
> > How do I determine what row number the TARGET is located in for a
> > WORKSHEET_Change event. My target MUST be one cell or this piece of the
> > code won't work.
> >
> > Can someone assist?
> >
> > Thanks,
> > Barb Reinhardt
>
>
>

[Bernie Deitrick]

Target is the changed range object:

If Target.Cells.Count > 1 Then
Msgbox "More than one cell!"
Exit Sub
End If
myRow = Target.Row
MsgBox "The changed cell was cell " & Target.Address & ", which is row " & myRow


--
HTH,
Bernie
MS Excel MVP


"Barb Reinhardt" <BarbReinhardt@discussions.microsoft.com> wrote in message
news:5FD7984B-7AA1-4AAE-8C5E-B35A2B9BA0B5@microsoft.com...
> I'm not sure I made myself clear. I could change a cell anywhere between
> D13 and D100 (for example) and I want to know what row # the cell was in.
> If I change D20, I want 20 returned. How do I do that?
>
> "Don Guillett" wrote:
>
>> how about
>> if target.address="$A$1" then
>>
>> --
>> Don Guillett
>> SalesAid Software
>> dguillett1@austin.rr.com
>> "Barb Reinhardt" <BarbReinhardt@discussions.microsoft.com> wrote in message
>> news:0945555D-AAF9-45DD-B6E6-EA289924CC41@microsoft.com...
>> > How do I determine what row number the TARGET is located in for a
>> > WORKSHEET_Change event. My target MUST be one cell or this piece of the
>> > code won't work.
>> >
>> > Can someone assist?
>> >
>> > Thanks,
>> > Barb Reinhardt
>>
>>
>>

[Bernie Deitrick]

Oh, and if you want to limit when the event is actually used,

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("D13:D100")) Is Nothing Then Exit Sub
If Target.Cells.Count > 1 Then
MsgBox "More than one cell!"
Exit Sub
End If
myRow = Target.Row
MsgBox "The changed cell was cell " & Target.Address & ", which is row " & myRow

End Sub

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
news:uvOAIa8tGHA.452@TK2MSFTNGP05.phx.gbl...
> Target is the changed range object:
>
> If Target.Cells.Count > 1 Then
> Msgbox "More than one cell!"
> Exit Sub
> End If
> myRow = Target.Row
> MsgBox "The changed cell was cell " & Target.Address & ", which is row " & myRow
>
>
> --
> HTH,
> Bernie
> MS Excel MVP
>
>
> "Barb Reinhardt" <BarbReinhardt@discussions.microsoft.com> wrote in message
> news:5FD7984B-7AA1-4AAE-8C5E-B35A2B9BA0B5@microsoft.com...
>> I'm not sure I made myself clear. I could change a cell anywhere between
>> D13 and D100 (for example) and I want to know what row # the cell was in.
>> If I change D20, I want 20 returned. How do I do that?
>>
>> "Don Guillett" wrote:
>>
>>> how about
>>> if target.address="$A$1" then
>>>
>>> --
>>> Don Guillett
>>> SalesAid Software
>>> dguillett1@austin.rr.com
>>> "Barb Reinhardt" <BarbReinhardt@discussions.microsoft.com> wrote in message
>>> news:0945555D-AAF9-45DD-B6E6-EA289924CC41@microsoft.com...
>>> > How do I determine what row number the TARGET is located in for a
>>> > WORKSHEET_Change event. My target MUST be one cell or this piece of the
>>> > code won't work.
>>> >
>>> > Can someone assist?
>>> >
>>> > Thanks,
>>> > Barb Reinhardt
>>>
>>>
>>>
>
>