+ Reply to Thread
Results 1 to 4 of 4

Quick Question: Select Case to identify if first character of a cell is "6"

  1. 05-16-2013, 09:40 AM #1
    exlgh91
    exlgh91 is offline
    Registered User
    Join Date
    05-10-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    26

    Quick Question: Select Case to identify if first character of a cell is "6"

    Hello, currently, I have the following code to classify each account.

    For this macro, if a value in .Cells(i, accName_col).Value starts with 6xxxxxxx
    I would like to classify it as TDWIS.

    This is the following code that I have:
    Please Login or Register  to view this content.
    Thanks in advace.
    Last edited by Leith Ross; 05-16-2013 at 01:40 PM. Reason: Added Code Tags
    Reply With QuoteRegister To Reply
  2. 05-16-2013, 09:42 AM #2
    JosephP
    JosephP is offline
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    re: Quick Question: Select Case to identify if first character of a cell is "6"

    perhaps
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to
    Reply With QuoteRegister To Reply
  3. 05-16-2013, 10:10 AM #3
    exlgh91
    exlgh91 is offline
    Registered User
    Join Date
    05-10-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    26

    re: Quick Question: Select Case to identify if first character of a cell is "6"

    thank you so much! it works great smarts...!
    Reply With QuoteRegister To Reply
  4. 05-16-2013, 10:25 AM #4
    JosephP
    JosephP is offline
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    re: Quick Question: Select Case to identify if first character of a cell is "6"

    you're welcome :-)

    don't forget to mark the thread solved
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1