How do I hide or unhide zero value columns/rows USING A MACRO?

's Computer Specifications

's Computer Specifications

Apply data|filter|autofilter
record a macro when you show the rows that have a value not equal to 0.

And you'll your code.

paul wrote:

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
zero value removes columns. How do I keep columns with zero value	=?Utf-8?B?amFja2ll?=	Microsoft Excel Charting	0	16th May 2007 09:10 PM
Make cell value zero if cell formula returns value less than zero?	Fred Ernst	Microsoft Excel Misc	2	20th Feb 2007 05:57 PM
if less then zero put zero if greater then zero state number	=?Utf-8?B?UGFtZWxhIEplYW4=?=	Microsoft Excel Worksheet Functions	2	17th Oct 2006 08:36 PM
Hide Unhide Hide again	=?Utf-8?B?RFRUT0RHRw==?=	Microsoft Excel New Users	1	15th Feb 2006 04:22 PM
Unhide line if value is greater than zero	Van Merrill	Microsoft Excel Worksheet Functions	1	24th Nov 2003 06:06 PM