LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default hide #VALUE! and ######

XL2000
is there a way to hide #VALUE! and ###### until needed or used

Is it possible to hide rows of formulas using a code

I know that I can hide them everyday by format rows/hide

today i will enter info in rows 25 and 26 but there is unused
information in rows 27 through 100
tomorrow i will enter info in rows 27 an 28 and so on

the unused rows have conditional formatting and it makes my eyes cross
looking at tomorrow's rows since
the conditional formatting is missing information
Thank you Alan at

 
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 do you hide/un-hide the grid lines ED Excel Discussion (Misc queries) 4 February 26th 13 03:22 PM
Want to Hide columns in spreadsheet but NOT hide data in chart. KrispyData Charts and Charting in Excel 1 March 20th 09 04:45 PM
How do I hide hide #REF! in Excel PerryK Excel Discussion (Misc queries) 3 February 27th 09 02:59 PM
Hide Unhide Hide again DTTODGG New Users to Excel 1 February 15th 06 03:22 PM
How do I hide a worksheet in Excel and use a password to un-hide . Dchung Excel Discussion (Misc queries) 3 December 2nd 04 06:24 AM


All times are GMT +1. The time now is 07:44 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"