Results 1 to 5 of 5

Relative Locations

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2011
    Location
    Portland, OR
    MS-Off Ver
    Excel 2011
    Posts
    4

    Relative Locations

    I'm making a price-estimating sheet for our office. So far I've got everything working the way I want. The sheet takes up cells A1 through O23. Various drop-down lists within the estimator trigger certain macros to run, changing other areas of the sheet.

    My question is what is the best way to reference certain cells in the sheet without referring directly to their address? The reason for this is that I am planning on duplicating the exact same section multiple times on one sheet, with each one acting independently from the other.

    So for instance, pushing the reset button should only effect the region from A1 to O23. If I have a duplicate of A1:O23 below in the area A24:O66, and I push its reset button, again, it should only effect A24:066. The same goes for selecting other portions of the list.

    I can make this work by writing massive code and very repetitive code specifying certain ranges and such, but for cleanliness, I want code that can work for as many duplicates as I want.

    Hopefully I've been somewhat clear on this. I've posted a couple of screen shots aswell,

Thread Information

Users Browsing this Thread

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

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