Results 1 to 10 of 10

Deleting Rows based on their value

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2008
    Posts
    8

    Deleting Rows based on their value

    Hi,
    I am having trouble with the .SpecialCells(xlCellTypeBlanks)
    What I need to do is for a macro to first go through a range ("G8:G50"), Add a 0 value to any blank cell.
    Then I want the macro to delete the entire row for any of the cells that have a value of 0 in that range of "G8:G50"
    Last edited by peteynub; 06-26-2008 at 09:57 AM.

Thread Information

Users Browsing this Thread

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

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