Posted to microsoft.public.excel.programming

juergenkemeter[_5_] juergenkemeter[_5_] is offline

external usenet poster

Posts: 1

VBA - remove all empty rows in a worksheet

Hi!
is there a way in VBA to remove all empty rows in a worksheet
'Sheet1'?

Cheers
Juergen

--
juergenkemeter
------------------------------------------------------------------------
juergenkemeter's Profile: http://www.excelforum.com/member.php...o&userid=25248
View this thread: http://www.excelforum.com/showthread...hreadid=499951

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
how to remove empty rows?	Joe	Excel Discussion (Misc queries)	2	January 6th 08 05:10 PM
How do I remove empty Rows	Rodders	Excel Discussion (Misc queries)	2	January 12th 07 12:04 PM
Remove empty rows in excel?	Clbmgr	Excel Discussion (Misc queries)	6	December 2nd 04 02:02 AM
remove all blank or empty rows	[email protected] [email protected]	Excel Programming	8	January 18th 04 07:55 PM
Remove empty rows	Kaj Pedersen	Excel Programming	15	November 2nd 03 07:22 PM

All times are GMT +1. The time now is 10:33 AM.

About Us

"It's about Microsoft Excel"