Delete a range of rows

  • Thread starter Thread starter Lotto
  • Start date Start date
L

Lotto

I want to change the code below to have a floating range, not fixed.
I"m sure this very simple, can someone help?

Range("P2").Select
Selection.End(xlDown).Select
Rows("2:77").Select
Range("I77").Activate
Selection.Delete Shift:=xlUp
 
Lotto,

Range(Range("P2"), Range("P2").End(xlDown)).EntireRow.Delete

HTH,
Bernie
MS Excel MVP
 
Back
Top