Posted to microsoft.public.excel.programming

Robert Lowe Robert Lowe is offline

external usenet poster

Posts: 4

DELETING BLANK ROWS

Thank you both, they work great!

Regards
Robert

"Robert Lowe" wrote in message
.. .
Hello,

I there an easy way to delete all rows if a certain colum is blank?
I have 5000 rows and wish to delete all, f colum b is blank.

Thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 blank rows	KRK	New Users to Excel	3	June 27th 09 12:51 PM
Deleting blank rows	Yvette	Excel Worksheet Functions	3	June 9th 06 10:30 AM
Deleting Blank Rows	Reeni	New Users to Excel	4	December 15th 05 01:56 AM
deleting blank rows	Ryan H.	Excel Programming	2	August 3rd 04 03:27 AM
Deleting Blank Rows	LC[_5_]	Excel Programming	1	June 3rd 04 06:55 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us