How do I select and delete row 80 to the last row which is 65,000?

Rows(80).Resize(Cells(Rows.Count,"A").End(xlUp).Ro w-79).Delete

--
__________________________________
HTH

Bob

"da" wrote in message
...
How do I select and delete row 80 to the last row which is 65,000?

Sorry, but I don't understand what you wrote.
Is there any keys I can use to select all the rows from row 80 to row 65556,
which is last row? There is some format and lines which I want to delete.
Thanks

"da" wrote:

How do I select and delete row 80 to the last row which is 65,000?

Manually?

Hit F5
type:
80:65536

rightclick on the selected area and choose delete

da wrote:

How do I select and delete row 80 to the last row which is 65,000?

--

Dave Peterson

Thank you, it worked.

"Dave Peterson" wrote:

Manually?

Hit F5
type:
80:65536

rightclick on the selected area and choose delete

da wrote:

How do I select and delete row 80 to the last row which is 65,000?

--

Dave Peterson

You can also click on row 80, (F8) (F8 is a marking tool) and then ctrl+down
arrow. This should take you straight to the bottom. You can then delete
rows.

If you're trying to clear the area, once you delete, do a save and then do a
ctrl-end to be sure that the last "active" cell is in row 80. Good luck!

"Dave Peterson" wrote:

Manually?

Hit F5
type:
80:65536

rightclick on the selected area and choose delete

da wrote:

How do I select and delete row 80 to the last row which is 65,000?

--

Dave Peterson

I find Dave's method best but there is a keystroke method.

Select row 80 then SHIFT + End + DownArrow.

EditDelete


Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 09:38:14 -0700, da wrote:

Sorry, but I don't understand what you wrote.
Is there any keys I can use to select all the rows from row 80 to row 65556,
which is last row? There is some format and lines which I want to delete.
Thanks

"da" wrote:

How do I select and delete row 80 to the last row which is 65,000?

That might not go all the way to the bottom of the data (or the bottom of the
worksheet).

Select A80
then ctrl-shift-end
will select A80 through the last used cell on the sheet (also not usually the
last row in the worksheet).

Then Edit|delete|entire row

Gord Dibben wrote:

I find Dave's method best but there is a keystroke method.

Select row 80 then SHIFT + End + DownArrow.

EditDelete

Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 09:38:14 -0700, da wrote:

Sorry, but I don't understand what you wrote.
Is there any keys I can use to select all the rows from row 80 to row 65556,
which is last row? There is some format and lines which I want to delete.
Thanks

"da" wrote:

How do I select and delete row 80 to the last row which is 65,000?

--

Dave Peterson

Depends on how the data is laid out and if there are any gaps.

smartgal wrote:

You can also click on row 80, (F8) (F8 is a marking tool) and then ctrl+down
arrow. This should take you straight to the bottom. You can then delete
rows.

If you're trying to clear the area, once you delete, do a save and then do a
ctrl-end to be sure that the last "active" cell is in row 80. Good luck!

"Dave Peterson" wrote:

Manually?

Hit F5
type:
80:65536

rightclick on the selected area and choose delete

da wrote:

How do I select and delete row 80 to the last row which is 65,000?

--

Dave Peterson


--

Dave Peterson

Faulty assumer in action again.

Row 80 to 65536 must be blank


Gord

On Fri, 01 Aug 2008 15:36:03 -0500, Dave Peterson
wrote:

That might not go all the way to the bottom of the data (or the bottom of the
worksheet).

Select A80
then ctrl-shift-end
will select A80 through the last used cell on the sheet (also not usually the
last row in the worksheet).

Then Edit|delete|entire row

Gord Dibben wrote:

I find Dave's method best but there is a keystroke method.

Select row 80 then SHIFT + End + DownArrow.

EditDelete

Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 09:38:14 -0700, da wrote:

Sorry, but I don't understand what you wrote.
Is there any keys I can use to select all the rows from row 80 to row 65556,
which is last row? There is some format and lines which I want to delete.
Thanks

"da" wrote:

How do I select and delete row 80 to the last row which is 65,000?

Or a perfect assumption--depends on what the OP really has!

Gord Dibben wrote:

Faulty assumer in action again.

Row 80 to 65536 must be blank

Gord

On Fri, 01 Aug 2008 15:36:03 -0500, Dave Peterson
wrote:

That might not go all the way to the bottom of the data (or the bottom of the
worksheet).

Select A80
then ctrl-shift-end
will select A80 through the last used cell on the sheet (also not usually the
last row in the worksheet).

Then Edit|delete|entire row

Gord Dibben wrote:

I find Dave's method best but there is a keystroke method.

Select row 80 then SHIFT + End + DownArrow.

EditDelete

Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 09:38:14 -0700, da wrote:

Sorry, but I don't understand what you wrote.
Is there any keys I can use to select all the rows from row 80 to row 65556,
which is last row? There is some format and lines which I want to delete.
Thanks

"da" wrote:

How do I select and delete row 80 to the last row which is 65,000?

--

Dave Peterson