abdo meghari
Well-known Member
- Joined
- Aug 3, 2021
- Messages
- 570
- Office Version
- 2019
Hi
I search for procedure to ignore lastrow contains NET word in lastrow, the lastrow(NET) is in column A , also the lastrow(NET) will be change in row number because I will add new rows before it . based on this part
the last row(NET) is 26 ,but as I said he lastrow(NET) will be changed in row number after add new rows.
the question is how I can exclude the last row(NET) from implementation code for it?
others meaning : when reach last row (NET) should not implement for lastrow(NET)
thanks
I search for procedure to ignore lastrow contains NET word in lastrow, the lastrow(NET) is in column A , also the lastrow(NET) will be change in row number because I will add new rows before it . based on this part
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("B12:D26")) Is Nothing Or Target.CountLarge > 1 Then Exit Sub
'rest of the code
'
'
'
End Sub
the question is how I can exclude the last row(NET) from implementation code for it?
others meaning : when reach last row (NET) should not implement for lastrow(NET)
thanks