basic excel question - Xtreme Visual Basic Talk

03-22-2003, 11:12 AM

zugdud

Newcomer

Join Date: Jan 2003

Posts: 12

basic excel question

Greetings, How can i remove blank rows from a worksheet? I have a worksheet with 7000 rows of data and the worksheet contains 2000 blank rows making a total of 9000 rows. I would like to elminiate these 2000 blank rows at the end of the work sheet. Thanks, any help appricated

03-22-2003, 11:37 AM

McF

Junior Contributor

Join Date: Feb 2003

Location: South Carolina

Posts: 215

Quote:
Originally Posted by zugdud
Greetings, How can i remove blank rows from a worksheet? I have a worksheet with 7000 rows of data and the worksheet contains 2000 blank rows making a total of 9000 rows. I would like to elminiate these 2000 blank rows at the end of the work sheet. Thanks, any help appricated

Try:
You can click on one or more column letters or one or more row numbers in the frame area, and click on Edit on the menu bar. Select the option of Delete and the highlighted column or row would be deleted. These columns or rows can be empty or contain information.

__________________
"Success is dependent on effort."~Sophocles
"Behold the turtle. He makes progress only when he stick his neck out."~James Bryant Conant

03-22-2003, 12:50 PM

Wamphyri

Variable not defined

Retired Moderator
* Guru *

Join Date: Apr 2002

Location: Ottawa, Ontario

Posts: 4,793

If all the rows containing data have data in a certain Column you could write a quick little macro to erase all rows that do not contain data in that cell

Code:

For i = Worksheets(1).UsedRange.End(xlDown).Row To 1 Step -1
    'Is the cell at (row i, column 1) empty
    If Cells(i, 1).Value = "" Then
        Cells(i, 1).Delete
    End If
Next

__________________
-Carl

03-23-2003, 12:08 AM

zugdud

Newcomer

Join Date: Jan 2003

Posts: 12

thanks alot man, that seemed to do the trick!

03-24-2003, 06:22 AM

Mill

Just another Excel nerd

Retired Moderator
* Guru *

Join Date: Feb 2000

Location: Michigan, USA

Posts: 2,624

Here's a method that checks to make sure the entire row is empty:

http://www.j-walk.com/ss/excel/tips/tip56.htm

__________________
"The face of a child can say it all, especially the mouth part of the face." - Jack Handey

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MsFlexGrid & VBA	msl	Word, PowerPoint, Outlook, and Other Office Products	2	09-17-2006 03:21 PM
Easy excel question	blitz84	Word, PowerPoint, Outlook, and Other Office Products	4	03-05-2003 09:16 AM
OLE, Excel, Visual Basic...	VBGestapo	Word, PowerPoint, Outlook, and Other Office Products	8	08-01-2002 02:51 PM
Excel to Text question	bene	Word, PowerPoint, Outlook, and Other Office Products	2	02-27-2002 08:11 AM
Using Excel by Visual Basic	toekreem	Word, PowerPoint, Outlook, and Other Office Products	10	01-17-2002 08:44 AM