Results 1 to 5 of 5

Thread: blank cell

  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts
    If I use a formula e.g.; =IF(ISNUMBER(D28207),D28207+38.21,"") and then do an edit/paste/special/values the end/down arrow key sequence doesn't read the pasted "" cells as blank. How do I make these cells blank so the end/down arrow works?

    Thanks!

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,199
    Thanks
    48
    Thanked 986 Times in 916 Posts
    The cell is not blank it has a formula, so the search for blank fails. I don't think you can get around this.

    cheers, Paul

  3. #3
    Star Lounger
    Join Date
    Dec 2009
    Location
    Mexico City, D.F., Mexico
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I cannot reproduce the behavior. If I copy/paste special/values/ a range containing formulas with resulting blank cells, I obtain empty cells and the up and down arrows properly jump from ranges of filled cells to the last filled and from the first empty to the last empty. Which version of Excel do you use?
    This eco-post is made of recycled electrons

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    A Lounge Search brings up this post. I'm not certain whether the code works on multiple blanks, but it should give you a start.

    It certainly has worked for me in the past.
    Gre

  5. #5
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts
    this is in Excel 2007

    Thanks for the input

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •