+ Reply to Thread
Results 1 to 2 of 2

offsetting rows

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    offsetting rows

    Hello. This formula copies rows with constants into a section to the right and then goes to the next line after each copy. For the last line, why do they use rng.rows.count as opposed to just offset one row. It seems like offsetting rows.count would increase the space between rows as the input gets bigger...1,2,3,4, etc.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: offsetting rows

    Nn this case each rng is an area (any you are looping through a number of areas), which can vary in number of Rows and Cols, so offsettting by rng.rows.count seems about right.

    For instance, if you had constant text with 3 numbers in next to each other in a column (say this is an area), you would need to offset by 3 and not just 1.

    Hope this helps..
    Last edited by berlan; 07-24-2015 at 02:39 PM.

+ 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. Deleting duplicate offsetting rows
    By bshbros in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2008, 05:30 PM
  2. Offsetting the Rows of a VLookup Result
    By Domenic in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-06-2005, 03:05 PM
  3. Offsetting the Rows of a VLookup Result
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. Offsetting the Rows of a VLookup Result
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. Offsetting the Rows of a VLookup Result
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. [SOLVED] Offsetting the Rows of a VLookup Result
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. Offsetting the Rows of a VLookup Result
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. Offsetting the Rows of a VLookup Result
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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