+ Reply to Thread
Results 1 to 2 of 2

Autofill of row or column

  1. #1

    Autofill of row or column


    Let's say I have a min, a max, and an increment, all decimal values. I
    want to autofill or autopopulate a row or column -- without manually
    dragging cels -- over the range [min,max] incrementing by the increment
    value each cell. Can this be done somehow? Also, what if you don't
    know how many cells you will need initially (you return some variable
    integer from a calculation)--can you tell Excel to fill only that
    number of cells each time? For example, let's say I compute some
    number and get a 7 one time and a 10 the next, and I want 7 cells
    filled with data and then on the next run, the originaly 7 wiped out
    and a new 10 filled. Is this possible?


  2. #2
    Registered User
    Join Date



    This can be done. However, I need to know what you mean when you say that the number of cells needed is a variable. Does this mean that your range of cells does not need to necessarily reach the max and the increment remains the same, or does this mean that your max must be reached in a certain number of cells and thus the increment will change?

    Also, what should happen when the difference between the min and max is not a perfect multiple of the increment?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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