+ Reply to Thread
Results 1 to 3 of 3

How to test if range selected fits criteria

  1. #1
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    334

    How to test if range selected fits criteria

    I have some code that runs on 'with selection', like this:

    Please Login or Register  to view this content.
    I am looking for a way to check that the selection is a range that is "A?:M?"
    e.g. 'A1:M10', or 'A5:M45' etc

    so that my code becomes something like this:

    Please Login or Register  to view this content.
    Any assistance appreciated.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: How to test if range selected fits criteria

    Hello,

    Here's a suggestion :

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    334

    Re: How to test if range selected fits criteria

    Thanks GG.

    Problem solved!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Loop issues - Find value in range that fits value in defined name range
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-31-2014, 11:33 AM
  2. Find smallest number that fits a criteria
    By HalPlz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2014, 03:49 PM
  3. Extracting data from column that fits criteria
    By Robo25 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-29-2013, 11:33 AM
  4. Help - Extracting an entire row that fits a single criteria
    By Babyanne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2009, 06:40 PM
  5. Look up that fits 2 criteria
    By njexpress9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2009, 04:53 PM

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