deleting rows after 3

[kishan]

basically i need some help deleting rows,
i want a button click to delete all the rows after 3. the
ones before 3 have text that i would like to stay, but
the rows after three need to be deleted. there is no
fixed end to the list as people add more rows - so the
delet function would need to delete ALL rows greater than
3. thanks

 

[Guest]

you could use a macro like:

Rows("4:65536").Delete Shift:=xlUp

 

[AlfD]

Hi!

The quickest help-yourself way would be to record a macro - rememberin
to assign a keyboard shortcut to it.


As you describe it, the macro could record you doing the following:

Select row 4
Extend the selection to the end of the worksheet (ctrl + shift + dow
arrow)
Delete (right click and select delete).

But there's many more ways of putting it together.

Al