LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
PBJ PBJ is offline
external usenet poster
 
Posts: 19
Default Using VBA to Conditional Hide Rows?

I have a sheet with a very long list of items in Column A, which may ormay
not have figures in the columns to the right. Since the list is so long, I'd
really like to only see those rows in which an item iin the first column does
have non-zero figures to the right. I can do this manually, I know, but this
sheet updates and is printed daily, and it would save a LOT of time and paper
if I could program it so that the rows would hide whenever there are all
zeroes to the right.

I'd think I should be able to do something in VBA so tha rows conditionally
hide when--to use row 2 as an example-- cells B2:Z2 = 0. Is this possible?

Thanks for any help anyone can offer.
 
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
How can I use conditional formatting to hide or delete rows? linda.beautiful.california Excel Worksheet Functions 6 July 15th 08 09:09 PM
Conditional Formatting to Hide Rows or Columns? sczegus Excel Discussion (Misc queries) 3 September 27th 06 09:32 PM
Hide Rows - copy and paste only rows that show Access101 Excel Worksheet Functions 3 March 1st 06 12:39 AM
Conditional Hide/Unhide Rows Gwen H Excel Discussion (Misc queries) 4 March 30th 05 06:52 AM
CAN I HIDE ROWS WITH CONDITIONAL FORMATTING? Likepike Excel Discussion (Misc queries) 2 December 21st 04 04:02 PM


All times are GMT +1. The time now is 02:08 PM.

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

About Us

"It's about Microsoft Excel"