Thread: clear all raws after 5000th
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
  
Posts: 2,494
Default clear all raws after 5000th
Worksheets("Sheet1").Rows("5001:" & Rows.Count).Clear


--

Gary Keramidas
Excel 2003


"pls123" wrote in message
...
hello again !
How can i do that ???
tx !

Reply With QuoteReply With Quote