+ Reply to Thread
Results 1 to 3 of 3

Need help to delete rows based on cell content

  1. #1
    Forum Contributor
    Join Date
    08-08-2006
    Posts
    203

    Need help to delete rows based on cell content

    I need a macro that will delete rows when column A doesnt contain certain things.
    Here is a sample
    Please Login or Register  to view this content.
    I want all rows deleted unless column A contains "Distribution", "Purchase", or a Number 1-9

    Result:
    Please Login or Register  to view this content.
    Thank you

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Try this code and report back:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-08-2006
    Posts
    203
    Quote Originally Posted by BigBas
    Try this code and report back:
    That did it!

    Thank you very much!

+ Reply to Thread

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