+ Reply to Thread
Results 1 to 3 of 3

Problem with .SpecialCells(xlCellTypeBlanks)

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    Asia
    MS-Off Ver
    Excel 2007
    Posts
    23

    Problem with .SpecialCells(xlCellTypeBlanks)

    Hi,
    I have a problem with the following code.
    For some reason it does not delete all of the rows that are blank in Column H.
    Please Login or Register  to view this content.
    Can anyone tell me what is wrong?

    Kind regards

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Problem with .SpecialCells(xlCellTypeBlanks)

    Should be

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Problem with .SpecialCells(xlCellTypeBlanks)

    Hi, Nils88,

    the code performs exactly what you tell it to do: build a range on all visible cells in Range H, limit that to those which are blanks and delete only the visible rows of blanks.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Run-time Error Multiple Selections SpecialCells xlCellTypeBlanks
    By goss in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2012, 08:59 PM
  2. [SOLVED] What does SpecialCells(2) mean?
    By AB33 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-01-2012, 11:40 AM
  3. Delete based on xlCellTypeBlanks when cell value = ""
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2010, 08:23 PM
  4. [SOLVED] SpecialCells
    By Peter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2006, 09:10 AM
  5. Specialcells
    By Bruno Uato in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-07-2005, 03:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1