How Do I Delete a Massive Amount of Information On An Excel Page

[zotah]

How Do I Delete a Massive Amount of Information On An Excel Page.

I have rows 1-8800 with information I don't want to delete.

I have rows 8801 to 145,000 with information I do want to delete completely

If I highlight 8801 and drag it down to row 145,000 and then right click and delete the information it will takes me over 20 minutes to delete this information.

Is there a simple faster way to delete this information without dragging it down the page and slowing waiting for everything to get highlighted and then deleteing it.

Thanks
Zotah

 

[Michael M]

try

Sub delem()
Application.ScreenUpdating = False
Rows("8801:145000").EntireRow.Delete
Application.ScreenUpdating = True
End Sub

 

[marious]

F5 and select the appropriate range
XL 13 64 Bit

 

[zotah]

F5 and select the appropriate range
XL 13 64 Bit

Can you help me understand what you mean by select the appropriate range?

I'm trying to be able to select the appropriate range of cells without dragging it down the page to highlight it for 20 minutes. Can you help me understand how I can select the appropriate range area without having to manually select it?

Thanks

Zotah

 

[zotah]

try

Sub delem()
Application.ScreenUpdating = False
Rows("8801:145000").EntireRow.Delete
Application.ScreenUpdating = True
End Sub

Where do I put this code to get the job completed?

thanks
Zotah

 

[zotah]

F5 and select the appropriate range
XL 13 64 Bit

I'm not understanding you when you say select the appropriate range? Can I select this huge range of cells without highlighting for 20 minutes down the page?

Thanks,
Zotah

 

[marious]

Yes, F5 and just type 88101:145000

 

[Michael M]

Paste the code in "This Workbook" module

 

[zotah]

Paste the code in "This Workbook" module

Sorry but where is the Workbook module exactly?

Thanks

Zotah

 

[Michael M]

Follow these steps

1. Copy the code
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.