I'm wondering how I can use variable here:
Sub Delete_Till()
Dim Del_Till As Integer
Del_Till = Range("h1").Value
Rows("2:100").Delete Shift:=xlUp
End Sub
I need use variable value instead of ex. 100 above.
This does not work:
Sub Delete_Till()
Dim Del_Till As Integer
Del_Till = Range("h1").Value
Rows("2:Del_Till").Delete Shift:=xlUp
End Sub
-Thank, Jackie
Bookmarks