Select Area - Line "X" to end of sheet

[pzamory]

How would I remove Lines 100 to 5000 without selecting them by scrolling down with the mouse? Thanks.

 

[smozgur]

I would activate the sheet in question and go to VBE (Alt+F11) and get into Immediate window (Ctrl+G) then copy and paste the following code line into this pane:

ActiveSheet.Range("A100:A5000").EntireRow.Delete

Then finally hit Enter key to execute the code.

Or following will select the rows you need when executed:

ActiveSheet.Range("A100:A5000").EntireRow.Select

and now you don't need to select them by scrolling down.

 

[pgc01]

Hi pzamory

To select the rows

- press F5 (GoTo)
- enter in the reference

100:5000

- press OK

Then right-click on the rows-> delete