Consulting

Results 1 to 3 of 3

Thread: Solved: Autofill Series with a minimum and maximum

  1. #1
    VBAX Newbie
    Joined
    Aug 2012
    Posts
    5
    Location

    Post Solved: Autofill Series with a minimum and maximum

    I can't seem to find the answer to this anywhere...

    I'm working on building a tool that requires a sequential list of numbers with a given (though variable) minimum and maximum value. Incidentally, the space between the numbers can be variable as well as it has to do with salary levels.

    Is there a way I can do a macro to automatically fill the list sequentially (i.e. $150, $151, $152) given a minimum and a maximum in unique cells?

    Or is there an easier way to do this that's not using Macros? Any help would be greatly appreciated!!

    Thanks!!

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    see attached.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Newbie
    Joined
    Aug 2012
    Posts
    5
    Location
    This is perfect-thanks so much!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •