Results 1 to 2 of 2

Thread: Excel, cell within range

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2002
    Location
    UK
    Posts
    506

    Excel, cell within range

    I've got this piece of code to check if a cell is within a range but I'm using it against a pre-defined table, just curious if there is any built-in function for doing this?

    At the mo I'm thinking of making my own function based on the code below.
    VB Code:
    1. If Application.Intersect(Range("B5"), ActiveWorkbook.Names("drivers").RefersToRange) Is Nothing Then
    2.     MsgBox "B5 is not in drivers range table"
    3.   Else
    4.     MsgBox "B5 is in drivers range table"
    5.   End If
    -adehh

  2. #2
    Addicted Member
    Join Date
    Aug 2002
    Location
    Luton, UK
    Posts
    178
    No built in function that I know of.
    Regards
    BrianB
    -------------------------------

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width