Delete rows Macro
 

Hi,

I need a macro that will select all rows from below the last entry to the
end of the workbook, and delete them. Deleting is fine, but can't get it to
find the last row with data and choose from below.

Ta,

Delete rows Macro
 

You cannot actually delete those rows, there will always be 65536 rows. If
you delete the last say 10 rows, Excel just inserts 10 new ones.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"smf" wrote in message
...
Hi,

I need a macro that will select all rows from below the last entry to the
end of the workbook, and delete them. Deleting is fine, but can't get it
to
find the last row with data and choose from below.

Ta,

Delete rows Macro
 

Ok, thats fine. That is what I want to do.

"Bob Phillips" wrote:

You cannot actually delete those rows, there will always be 65536 rows. If
you delete the last say 10 rows, Excel just inserts 10 new ones.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"smf" wrote in message
...
Hi,

I need a macro that will select all rows from below the last entry to the
end of the workbook, and delete them. Deleting is fine, but can't get it
to
find the last row with data and choose from below.

Ta,