View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lotto Lotto is offline
external usenet poster
 
Posts: 3
Default End (xlDown) question

I want to go to the end of column J, move up two rows, and delete the
last three rows. I'm just not sure how to get the delete range to
vary as I need it to. See code below:

Range("J2").Select
Selection.End(xlDown).Offset(-2, 0).Select
Rows("160:162").Select
Selection.Delete Shift:=xlUp
End Sub

Thanks in advance for your help!