Posted to microsoft.public.excel.worksheet.functions

Yvette

Posts: n/a

Deleting blank rows

Hi ppl,

After pasting and sorting say A1:F20 any blanks always end up top when using
an acsending sort.

How can I (using code) delete any blank rows.

TIA

Yvette

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
resetting last cell	jagdish.eashwar	Excel Discussion (Misc queries)	11	March 31st 06 02:06 AM
Hiding Rows Leaves Labels Blank	Laura	Excel Discussion (Misc queries)	3	March 24th 06 01:10 PM
Deleting Unique Rows	MWS	Excel Discussion (Misc queries)	1	March 21st 06 09:37 PM
Help!! I have problem deleting 2500 rows of filtered rows!!!!	shirley_kee	Excel Discussion (Misc queries)	1	January 12th 06 03:24 AM
Blank Rows	Acesmith	Excel Discussion (Misc queries)	1	November 30th 04 09:23 PM

All times are GMT +1. The time now is 02:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us