Posted to microsoft.public.excel.programming

Lillian[_3_] Lillian[_3_] is offline

external usenet poster

Posts: 7

how to delete empty row in vba

I have one excel spreed sheet, I need to delete all the
empty row, also some of cell in columnF if is the space,
then this record need to delete as well.
Anyone know how to write the vba macro?

thanks.

Lillian

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
delete row if 2 cells are empty	Wanna Learn	Excel Discussion (Misc queries)	1	November 19th 09 10:20 PM
If cell empty delete row	Clive[_2_]	Excel Discussion (Misc queries)	1	November 8th 09 12:51 AM
Delete Row If Empty Macro	Richard	Excel Discussion (Misc queries)	3	January 20th 06 11:26 PM
Delete rows if they are empty	chrismania[_7_]	Excel Programming	4	October 27th 03 12:32 AM
Delete rows if they are empty	chrismania[_3_]	Excel Programming	2	October 18th 03 04:27 PM

All times are GMT +1. The time now is 11:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us