Results 1 to 5 of 5

block relative addressing..

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2008
    Location
    iowa
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    63

    block relative addressing..

    I have a named block, used to sort a list of data. But I names the block one row higher to include the headers, so that inserts at the top row of the data would not fall out of the named range.

    Then I want to sort the data, but not include the header row.

    How?

    What I want to say in the sort macro is something like:
    cell_range( top_row(Data)-1, Bottom_Row(Data) )

    Or, to have two names, with one defined in terms of the other:
    Data_sort = Data_big - Toprow(Data_big)
    Last edited by guthrie; 10-23-2008 at 08:30 AM. Reason: solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Determining relative file path macro
    By ctmurray in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2007, 12:25 AM
  2. Prevent Yellow color from printing. Make visible gridlines in a shaded block
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2007, 08:22 PM
  3. Gantt chart using relative dates?
    By Poops in forum Excel General
    Replies: 1
    Last Post: 06-09-2007, 02:29 PM
  4. Using Relative & Abolute addressing
    By dar byrne in forum Excel General
    Replies: 4
    Last Post: 11-09-2006, 07:51 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