how use dynamic row in target range in worksheet_change event

[abdelfattah]

Hi Guys,
I search for using dynamic row for range "B12:D20" instead increase or decrease number row for the lastrow.
currently I try changing this

If Intersect(Target, Range("C12:E20")) Is Nothing Or Target.CountLarge > 1 Then Exit Sub

to this

a = If Intersect(Target,Range("C12", Target.Range("E" & Rows.Count).End(3)).Value) s Nothing Or Target.CountLarge > 1 Then Exit Sub

but this doesn't work totally .how I can do that guys?

 

[RudRud]

If Intersect(Target, Range("c12:e" & Cells(Rows.Count, "E").End(xlUp).Row)) Is Nothing Or Target.CountLarge > 1 Then Exit Sub

Column E got value right?

 

[abdelfattah]

Column E got value right?

Yes should be, but doesn't work when enter value in column E !

 

[DanteAmor]

Try:

If Intersect(Target, Range("C12:E" & Rows.Count)) Is Nothing Or Target.CountLarge > 1 Then Exit Sub

 

[abdelfattah]

@DanteAmor
this works !
thank you so much .