LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Delete all rows below my data to the bottom of the sheet

I am dealing with large blocks of data, ranging from 10,000 to 20,000 rows.

Is there a simple way I can use code to delete all rows below my data, down
to the very bottom of the spreadsheet? The # of rows will not be the same
each time.

Any help is greatly appreciated.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete extra rows from bottom? Lentenrose Excel Discussion (Misc queries) 1 November 10th 06 05:23 PM
How do I repeat rows on the bottom of each sheet in excel? Asma Excel Worksheet Functions 1 March 15th 05 09:37 PM
How do I delete blank rows at the bottom of a spreadsheet to get . Miklaurie Excel Discussion (Misc queries) 1 January 26th 05 02:30 PM
NEED TO REPEAT ROWS AT THE BOTTOM OF EXCEL SPREAD SHEET AQ Mahomed Excel Programming 5 June 7th 04 02:13 PM
Go to last row of data and delete the rest to bottom of s/sheet Tempy Excel Programming 6 April 9th 04 12:33 PM


All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"