LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
steve alcock
 
Posts: n/a
Default why is my blank cell not a blank cell

Hi team,

this is probably basic but :

when I have a formula in a cell it is then deemed as not blank for when I am
making refereneces to it or it's range, #n/a - #value etc are returned when i
want it to be treated as blank.

anyone throw some light on this please

thanks

steve

 
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
Empty Cell ( blank Cell ) rocky Excel Worksheet Functions 2 April 28th 05 11:17 PM
Look for change next blank cell in Range Nigel Bennett Excel Worksheet Functions 1 March 13th 05 09:45 PM
Go to first blank cell Curt D. Excel Worksheet Functions 4 February 28th 05 10:27 AM
Ghost Blank Cell References David P Excel Worksheet Functions 1 February 4th 05 03:27 AM
how do i create a blank cell in excel using a formula Tosh Excel Worksheet Functions 1 November 2nd 04 04:22 PM


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