Results 1 to 4 of 4

Multiple Target Intersect Ranges on Same Worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2009
    Location
    Cardiff
    MS-Off Ver
    Excel 2010
    Posts
    25

    Multiple Target Intersect Ranges on Same Worksheet

    Can you use Select Case with multiple target intersects?

    For example I have several ranges that format time based on user entry and several ranges that hide rows or columns or force Upper case based upon a user inputting a value into a cell.

    I was thinking that I could use something like the below, but I can't figure out how to get the If statement in there

    Any help would be appreciated. Am I barking up the wrong tree?

    Select Case Target
    
    Case Application.Intersect(Target, Union(rng1, rng2, rng3, rng4))
    Do something
    
    Case Application.Intersect(Target, rng5)
    Do something
    
    Case Application.Intersect(Target, rng6)
    Do sometihng
    
    End Select
    Last edited by Mistweaver; 09-28-2013 at 04:36 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem with Intersect(Target)
    By fcarboni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2012, 09:02 AM
  2. If not Intersect multiple ranges
    By karl1985 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-28-2010, 12:52 PM
  3. Intersect 2 ranges in one Application
    By James12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2010, 04:52 PM
  4. [SOLVED] Utilize a Select Case Statement in Target Intersect Statement
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 08:55 PM
  5. [SOLVED] Ranges:Target in Worksheet_SelectionChange(ByVal Target As Range)
    By Kevin McCartney in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2005, 09:06 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