Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Confused
 
Posts: n/a
Default hide errors

I am working on creating a grade book for my school and the problem that I am
having is when I get across to the end of a column where I have this command
average(c8:av8) when I have no numerical entries I get a #DIV/0! error. After
reading through many different forums on hiding such numerous errors I still
can't figure out how to hide more than one at a time without them reappearing
once the first error has changed.
 
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
Tracking Errors Karen Excel Worksheet Functions 1 April 6th 06 01:34 PM
Macro to hide blank cells in a range Dave Excel Discussion (Misc queries) 1 February 1st 06 11:55 PM
hide errors when printing Natalie Excel Worksheet Functions 1 May 24th 05 08:56 PM
how do i hide value errors until data can be entered? cath_cw Excel Worksheet Functions 1 April 26th 05 06:08 PM
how do i hide value errors until data can be entered? cath_cw Excel Worksheet Functions 0 April 26th 05 05:58 PM


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