+ Reply to Thread
Results 1 to 3 of 3

Select Non Contiguous dynamic range

  1. #1
    Registered User
    Join Date
    10-09-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    13

    Select Non Contiguous dynamic range

    I am trying to select a range that is dynamically generated where the rows and columns are not equal in length and there culd be empty cells.
    I know the top left cell and need to select all cells included, so basically the max column and max row.

    The sample.xlsm contains dynamically generated data. The top left cell of the range I would like to select is C3. In this example I would like to select the range C3:O16
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Select Non Contiguous dynamic range

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-09-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Select Non Contiguous dynamic range

    Thanks for your help!
    Sorry but not able to get this to work.
    Firstly why B3 if my top left cell is C3?
    I want to place a single line border around this selection

+ 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. [SOLVED] Select contiguous range by two header names
    By capson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2013, 08:08 PM
  2. Select & copy non-contiguous range
    By SunRise in forum Excel General
    Replies: 0
    Last Post: 01-08-2013, 05:56 PM
  3. Excel 2007 : Dynamic Line Graph with Non-Contiguous Range
    By amy_boogada in forum Excel General
    Replies: 1
    Last Post: 07-14-2012, 06:58 AM
  4. Select large non-contiguous range
    By kellywa in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-23-2008, 01:11 AM
  5. How to select a range of non-contiguous rows
    By rgans in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2005, 02:54 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