Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    delete blank line (2000 sr 1)

    .. in this sheet i set a filtre on column B and select blank cells, after i delete the range of blank cells.
    After this opeartion i reselect blank cells and appear the same range of blank cells??????????

    In this case i delete from 280 to the max extencion 65536

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: delete blank line (2000 sr 1)

    <P ID="edit" class=small>(Edited by tony55 on 22-Jul-04 16:57. Added Italian translation)</P>The range of cells that Excel believes is in the list of data is wrong. To correct this remove the autofilter then add the autofilter again. You will no longer have blank cells listed.

    Italian for autofilter
    Dati>Filtro>Filtro automatico

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: delete blank line (2000 sr 1)

    TKS. (Good italian) <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: delete blank line (2000 sr 1)

    Prego

Posting Permissions

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