+ Reply to Thread
Results 1 to 2 of 2

Selecting only cells that begin with certain values.

  1. #1
    Registered User
    Join Date
    12-13-2011
    Location
    Tennessee
    MS-Off Ver
    Excel 2007
    Posts
    3

    Selecting only cells that begin with certain values.

    My data looks like,
    1 - TOOL
    2-Feb
    3 - 1/16 FLAT CARBIDE ENDMILL2 FLUTE/ LOCATION 4G
    4 -
    5 - C00179
    6 -
    7 - 26 10 0 0.0625 0. 0. 180. 26 26 20. 80. 600. 10000 16 2 1 26
    8 - 0 50. 50. 25. 25. 0. 0. 0.
    9 - 0. 2. 3. 2.5 0.0625 2. 1. 0 100. 6. 0
    11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

    1 - TOOL
    2-Feb
    3 - 3/32 FLATCARBIDE ENDMILL 2 FLUTE /LOCATION 4G
    4 -
    5 - C00180
    6 -
    7 - 26 10 0 0.09375 0. 0. 180. 26 26 25. 80. 600. 10000 16 2 1 26
    8 - 0 50. 50. 25. 25. 0. 0. 0.
    9 - 0. 2. 3. 2.5 0.09375 2. 1. 0 100. 9. 0
    11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

    I only want to select the cells that start with 7-,9-.
    How would I do this in VBA?

    Best regards,

  2. #2
    Forum Contributor
    Join Date
    10-08-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    386

    Re: Selecting only cells that begin with certain values.

    Please Login or Register  to view this content.

+ 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