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: 2
Default Deleting 3 rows when current row number is unknown

Hello,
How do I delete the the next 3 rows of data when the row
number varies from worksheet to worksheet.
Example: My good data goes from Row 1 to Row 200.
I need to delete Rows 201 thru 203.
Example: My good data goes from Row 1 to Row 320.
I need to delete Rows 321 thru 323.

In other words the rows of good data vary from worksheet
to worksheet.

Thank you in advance.
Joe
 
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
deleting number and alphabet rows and coluns Maryann Excel Discussion (Misc queries) 1 May 17th 08 05:12 PM
Formula's dealing with unknown number of rows OfficeNDN Excel Discussion (Misc queries) 2 September 11th 06 04:11 PM
Deleting rows with repeated number Mark Lopa Excel Programming 2 March 4th 04 01:50 PM
deleting variable number of rows Nick Excel Programming 1 October 29th 03 04:31 PM
Summing unknown number of rows Chris M.[_3_] Excel Programming 2 August 20th 03 05:48 PM


All times are GMT +1. The time now is 08:41 AM.

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

About Us

"It's about Microsoft Excel"