Thread: Change event
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Change event

Hi
the nature of this event is that it is only triggered then a change occurs.
Maybe you could describe what you're trying to achieve with this information

"Stefi" wrote:

In a
Private Sub Worksheet_Change(ByVal Target As Range)
procedure the Target variables returns the cell just left only if it has
been changed. I need this cell's row number even if it has NOT been changed.
Is there any way?
Thanks Stefi