Results 1 to 11 of 11

How to populate blank cells with sequence until nonblank cell is encountered?

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    28

    How to populate blank cells with sequence until nonblank cell is encountered?

    I've been looking around at the various sites, trying to find a code that either does this, or that I could easily adapt to my needs... But with no luck so far.

    I presume this is fairly simple to do, since it's certainly easy enough to do manually by filling in a couple of rows and dragging them down, but I need it to be performed in a macro that I can run before other macros run.


    What I need specifically is for the macro to go to G1 and insert the number .01... Then go to G2 and insert .02... Then G3 and insert .03... And repeat this until it finds the first non-blank cell ( row number this occurs at varies), at which point it ends and does nothing to that populated cell or any other cell in the column thereafter (including other blanks farther down).

    This all needs to be done in Arial, 10pt, white.


    Please help!
    Last edited by Jasonhouse; 03-27-2014 at 07:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 04-29-2013, 04:20 AM
  2. [SOLVED] If cell is not blank, assign next number in sequence
    By dylaughin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2012, 03:57 PM
  3. Replies: 2
    Last Post: 12-22-2011, 07:05 PM
  4. [SOLVED] How do I find the minimum NONBLANK value in a sequence of cells?
    By codeslinger in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-02-2005, 06:20 PM
  5. [SOLVED] How do I find the minimum NONBLANK value in a sequence of cells?
    By codeslinger in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-02-2005, 06:17 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