Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2004
    Location
    Portsmouth, Hampshire, England
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    When is a blank cell not a blank cell? (2002 SP3)

    No, this shouldn't be in Puzzles Forum!

    If you select a column and then ask Excel to Go To...->Blanks, it only considers cells to be blank if the "LastCell" property is set in or to the right of that column.

    Likewise, if you select a row, the "LastCell" property must be in or below that column.

    There doesn't actually have to be anything in the Last Cell however.

    Just thought that this information might be useful, 'cos it didn't seem to be documented in the help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: When is a blank cell not a blank cell? (2002 SP3)

    This is by design, and it's probably what most users expect. In most situations, it wouldn't make sense to select the millions of unused blank cells beyond the last used row and column.

Posting Permissions

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