+ Reply to Thread
Results 1 to 2 of 2

Macro auto-fill: Blocks of consecutive decimal numbers with blank row in between them

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    1

    Macro auto-fill: Blocks of consecutive decimal numbers with blank row in between them

    Hi All,

    This request seems pretty simple, I actually cannot believe that something similar hasn't already been done online! Hopefully, someone can help me. Struggling with Macros and VBA so thank you in advance! Please could you write literally everything I would need to paste into the Module?!

    I just need to populate Column A with consecutive numbers as follows WITH a blank row in between each number. I would MANUALLY enter 1.00 so the Macro would populate the numbers following this, ie. from 1.01 inclusive. If I entered 2.00 instead of 1.00, the numbering would start from there, so the next number the Macro would need to spit out would be 2.01, then 2.02... Same if I entered 3.00 or 4.00 etc etc.

    1.00

    1.01

    1.02

    1.03

    1.04

    ... etc etc. The ending number will be unknown but not large (ie, not a great number of rows), so ideally, the Macro would spit out blocks of 5 numbers at a time. Ie. When I run the Macro, it does...

    1.01

    1.02

    1.03

    1.04

    1.05

    Then every time I run the Macro as required, I could add the next 5 numbers in the sequence. So the second run of the Macro would spit out...

    1.06

    1.07

    1.08

    1.09

    1.10

    Remember... there needs to be a blank row inserted between each number.

    I can't imagine this is complex code for you guys to create?! Again, Many thanks.

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Macro auto-fill: Blocks of consecutive decimal numbers with blank row in between them

    You may try:
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

+ 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. Auto fill decimal sequence using custom fill or formula
    By 8cats in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-22-2013, 08:53 AM
  2. Replies: 17
    Last Post: 01-10-2011, 10:40 PM
  3. Excel macro to "fill in" consecutive numbers in non-consecutive list?
    By Tomkat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2009, 01:13 PM
  4. [SOLVED] How do I auto-fill dates that are not consecutive across a row?
    By paulfj@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2006, 05:00 PM
  5. How do I auto-fill consecutive dates ?
    By drschieff in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2005, 07:06 PM

Tags for this Thread

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