Delete rows

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,406
hi guys,

i am looking to modify some code. I have used macro recorder to get the following code

Code:
Cells.Find(What:="game stats", After:=ActiveCell, LookIn:=xlFormulas, _
        LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False).Activate
    ActiveWindow.SmallScroll Down:=6

what i need is to delete the row containing "game stats" and the next 20 rows aswell

but this code runs more than once, so i need code to specify the rows

hope this makes sense

dont need the scroll down bit either

thanks
 
Last edited:

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,108,979
Messages
5,526,023
Members
409,675
Latest member
audeser

This Week's Hot Topics

Top