Posted to microsoft.public.excel.misc

Nora_GG[_2_] Nora_GG[_2_] is offline

external usenet poster

Posts: 10

Remove columns with all zeros

How can I remove columns that contain all zeros? Is there a macro? I craeted
a sumif formula to flag columns subtotaling zero but I need a method to
remove these columns. Thanks

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
Remove columns containing all zeros	Nora_GG	Excel Worksheet Functions	2	June 1st 10 10:44 PM
Remove leading zeros	Machel	Excel Discussion (Misc queries)	9	February 14th 08 12:07 AM
remove preceding zeros	Bruce	Excel Worksheet Functions	2	July 27th 07 02:52 PM
REMOVE LEADING ZEROS	ichihina	Excel Worksheet Functions	2	March 14th 07 07:58 PM
Remove zeros	xgirl	Excel Worksheet Functions	8	April 13th 05 01:18 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us