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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks