#1   Report Post  
Old November 27th 04, 09:09 AM
Alan
 
Posts: n/a
Default AUTO HIDE ROWS

Is there a method/function to auto hide rows dependent on the value of a cell
in that row ...

Ie cell B3 = 0 ...... hide row ??!

Many thanks again

Alan

  #2   Report Post  
Old November 27th 04, 09:13 AM
Ron de Bruin
 
Posts: n/a
Default

Hi Alan

With VBA code it is possible to do a auto hide but maybe you
can use Autofiltercustom to do what you want

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alan" wrote in message ...
Is there a method/function to auto hide rows dependent on the value of a cell
in that row ...

Ie cell B3 = 0 ...... hide row ??!

Many thanks again

Alan





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Auto adjusting # rows between 2 worksheets kevin mckellar New Users to Excel 1 December 30th 04 03:01 PM
CAN I HIDE ROWS WITH CONDITIONAL FORMATTING? Likepike Excel Discussion (Misc queries) 2 December 21st 04 04:02 PM
Why can't I show or hide rows in an outline on a protected sheet? rwlass Excel Discussion (Misc queries) 1 December 9th 04 04:38 PM
Macro to hide rows with empty cells tp58tp Excel Worksheet Functions 2 November 13th 04 02:01 PM
Excel - if cells = 0, how to conditionally hide rows in chart fineimage Excel Worksheet Functions 1 November 11th 04 09:45 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017