Macro to delete rows before , between , after .

[Sunline]

Hello all , have searched for basic simple macro,s x 3 too to do the following individually but cant find any .
Book999 , sheetA .
Just wanting to get 3 x single macros to delete all rows before row 65001 .
Another for between rows 14,099 and 25,001 .
Another for after rows 65,000 .
Thanks .

 

[Rick Rothstein]

If I understand your request correctly, try these...

Sub RemoveBeforeRow65001()
  Rows("1:65000").Delete
End Sub
 
Sub RemoveRowsBetween14099and25001()
  Rows("14100:25000").Delete
End Sub
 
Sub RemoveRowsAfterRow65000()
  Rows("65000:" & Rows.Count).Delete
End Sub

 

[Sunline]

Thanks for those Rick , yes 3 individual macros , will try these out after work tonght .
Thankyou .