hi,
i am using below code to get last empty row of a range,
[CODE]Sub LastRowSelect()![]()
If Not Intersect(Target, Range("I10:I1000")) Is Nothing Then Call LastRowSelect End If
Dim lastrow As Long
lastrow = Range("F" & Rows.Count).End(xlUp).Row + 1
Range("F" & lastrow).Select
End Sub[/CODE
I need to change my code as
if next row of active cell has some data then exit the sub
for example
i type some data in Range("I15") and range("I16") has already data then don't run the macro name called "LastRowSelect"
thank you
hope some one will help
Bookmarks