+ Reply to Thread
Results 1 to 5 of 5

Script skips past numbers in an array.

  1. #1
    Registered User
    Join Date
    01-27-2015
    Location
    indiana
    MS-Off Ver
    2007
    Posts
    3

    Question Script skips past numbers in an array.

    I have the following script:
    Please Login or Register  to view this content.
    it is supposed to redact all lines except those that contain the numbers in the array.
    this was hobbled together from many other posts and is only partially my own code. any help would be appreciated.

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Script skips past numbers in an array.

    Well you're only looking at the first two values in the array, 206 and 215, at this line:

    Please Login or Register  to view this content.
    Otherwise, if the cell has anything else in it, your Else code will run.

    Try this in it's place:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-27-2015
    Location
    indiana
    MS-Off Ver
    2007
    Posts
    3

    Re: Script skips past numbers in an array.

    doing that gives me runtime error 13; type mismatch.

  4. #4
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Script skips past numbers in an array.

    Because I misspelled SearchValues. Add the "r" back in, you should be good.

  5. #5
    Registered User
    Join Date
    01-27-2015
    Location
    indiana
    MS-Off Ver
    2007
    Posts
    3

    Re: Script skips past numbers in an array.

    hrm; it runs without error but doesn't do the redactions. it drops the formula into the sheet then removes H:H... its supposed to delete lines without the numbers and turn them black placing "redacted" into column A...

+ 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. Is there any script that I generate 6 numbers of these numbers from the list?
    By dragon66 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2014, 01:22 PM
  2. Replies: 2
    Last Post: 02-28-2014, 10:15 PM
  3. [SOLVED] Ranking up to 15 numbers in column D Ranking skips 7 with a tie at 6 and 2
    By Securitysports in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2013, 07:11 AM
  4. Copy and past Array formula via macro
    By danfullwood in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 09:54 AM
  5. keep past date numbers
    By allgeef in forum Excel General
    Replies: 0
    Last Post: 06-17-2012, 03:11 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