Results 1 to 5 of 5

IF condition, check more than one cell then Select Case

Threaded View

blue.chio IF condition, check more than... 06-15-2013, 03:09 AM
Tinbendr Re: IF condition, check more... 06-15-2013, 08:51 AM
blue.chio Re: IF condition, check more... 06-15-2013, 09:37 AM
Tinbendr Re: IF condition, check more... 06-15-2013, 09:43 AM
blue.chio Re: IF condition, check more... 06-15-2013, 09:59 AM
  1. #1
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    IF condition, check more than one cell then Select Case

    Hello!

    I would like to expand this code to check more than one cell.
    If in Sheet2 cell H16 or H17 or H18 or H19 or M16 or M17 or M18 or M19="ABC"value and cell AD10=312A or 312B to add text in Sheet3.
    If the conditions are met to add some text.
    Thanks a lot for your help.


    this is what I have, it works but it checks sheet2 and one cell (m16) only.
    If Sheet2.Range("m16").Value = "ABC" Then
            Select Case Sheet2.Range("ad10").Value
             Case Is = "312A", "312B"
              Sheet3.[e16] = "Attn..."
              Sheet3.[a16] = "INFO"
            End Select
          End If
    blue
    Last edited by blue.chio; 06-15-2013 at 04:33 AM. Reason: check sh2 only

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