Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    21

    Unanswered: Cannot Find Blank Cells

    I have a sheet (attached) where I would like to use Edit, Go To, Special, Blanks to select the blank cells, delete them and move everything to the left.

    Yet when I do this I'm told there aren't any.

    Where are the wheels falling off?

    Jacque
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    I have experiance this too.

    I assume, like me, that this data has been exported from a DB using a recordset or similar, that the values written to the BLANK cells are in fact NULL.

    I this case it would seem that the cells are not truely blank (!!) thay just look that way. If you 'delete' the info from the blank cells then it all works are expected !?

    The IsEmpty function in VBA will differenciate between a 'Null' cell and a 'Blank' cell.

    Also, both COUNTBLANK() and COUNTA() worksheet function return 1 if applied to one of these 'NULL' cell ??

    Can anyone else shed anymore light on this phenomina ??


    MTB

  3. #3
    Join Date
    Sep 2005
    Posts
    21
    Check out
    http://www.utteraccess.com/forums/sh...Number=1189570

    I received my answer there and it works great!

Posting Permissions

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