Posted to microsoft.public.excel.programming

external usenet poster

Posts: 363

Deleting blank rows which contain blank drop-down list boxes

Is it possible for a macro to do this?

I have seen many macros designed to remove blank rows in Excel but I have
many spreadsheets which, while the trailing rows appear to be blank, some
have list boxes which have not been used (appear blank) and I'd like to
remove those.

Thanks
Al

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
Deleting blank rows	Rafeek	Excel Discussion (Misc queries)	5	August 27th 11 03:20 PM
Ignore blank rows to populate custom drop down list column range	vidtec	Excel Programming	3	April 24th 06 07:27 PM
Deleting Blank Rows	Reeni	New Users to Excel	4	December 15th 05 01:56 AM
Deleting blank rows	Alan M	Excel Programming	3	January 26th 05 01:12 PM
Deleting Blank Rows	LC[_5_]	Excel Programming	1	June 3rd 04 06:55 PM

All times are GMT +1. The time now is 10:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us