ExcelBanter - clear all raws after 5000th

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - clear all raws after 5000th (https://www.excelbanter.com/excel-programming/431926-clear-all-raws-after-5000th.html)

pls123

clear all raws after 5000th

hello again !
How can i do that ???
tx !

Gary Keramidas

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 !

All times are GMT +1. The time now is 03:43 AM.