Results 1 to 5 of 5

Returning A Range

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    40

    Returning A Range

    Hi,

    I have a very simple query that I'm sure someone will be able to solve in seconds.

    I have a spreadsheet and I'd like to get a specific range returned for use in a later function.

    The range itself starts in cell A3 and extends downwards until the cell just above an empty cell in the same column (A). The trick of course is that the number of cells with data in them may change and hence the position of the empty cell in column A may also change.

    I've attached a spreadsheet with a simple depiction of what I mean.

    Should you have any further questions or queries, please don't hesistate to ask.

    Many thanks in advance for your help,

    Kindest Regards,
    Twills.
    Attached Files Attached Files
    Last edited by twills; 07-19-2010 at 10:17 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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