+ Reply to Thread
Results 1 to 4 of 4

Delete row with values between 2 numbers

  1. #1
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Delete row with values between 2 numbers

    Hi,
    I need to delete rows containing values between 1900-1999 (col B)
    There are different values in column B (167....255...5234..2166, etc) but I want to delete those rows with 1900, 1901, 1902...1999.

    I use this
    Please Login or Register  to view this content.
    Thank you for all your help!
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Delete row with values between 2 numbers

    Give this a try.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Delete row with values between 2 numbers

    Thank you!
    This is it!

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Delete row with values between 2 numbers

    You're welcome and thanks for rep+.

+ 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. [SOLVED] Insert row numbers into column A, reflect correct row numbers when I add or delete rows
    By jcambell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2015, 02:18 PM
  2. [SOLVED] How to delete a row with specific values in a that fall between certain numbers
    By John Swift in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2014, 08:27 AM
  3. [SOLVED] Delete text, split numbers to two cells and store as numbers
    By Steve_123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2014, 09:51 AM
  4. Replies: 4
    Last Post: 10-05-2012, 08:23 AM
  5. Replies: 3
    Last Post: 10-05-2012, 06:38 AM
  6. [SOLVED] Delete Other Numbers Except Cell Numbers
    By it_electronics2000 in forum Excel General
    Replies: 43
    Last Post: 04-10-2012, 06:11 AM
  7. [SOLVED] delete numbers and replace with numbers from adjacent column
    By troysie in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-13-2010, 05:31 AM

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