Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: deleting rows

  1. #1
    Guest

    Default

    guys, how can I create a macro to delete a group of rows within a range (ie- C30 thru C55) if any of the cells in this range (C30-C55) are empty, leaving just those rows in that range that have text entries? Thanx!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is this what you want ?

    Range("C30:C55").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Guest

    Default

    It is probably what I want, but I am not exactly sure where to put this code (module, sheet, etc.) And is there anything else I need to add before/after the code? Thanks again!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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