Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Bakir Farooq on Mar 04 In MS Office Category.

selection help

Question Answered By: Vivian Ruiz on Mar 04

Steve, here is a one line command which deletes all rows above the last 10:

Range(Cells(1, 1), Cells(ActiveSheet.UsedRange.Rows.Count - 10,
1)).EntireRow.Delete

This Question has 2 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on selection help Or get search suggestion and latest updates.

Tagged:selection help

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us