Results 1 to 7 of 7

VBA. Fill empty cells with text "OPEN", I2 downwards, row count Col A

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    VBA. Fill empty cells with text "OPEN", I2 downwards, row count Col A

    Hi
    What would be the most efficient or easiest VBA to achieve below:

    VBA would fill all the all the empty cells in col I with value "OPEN". This would be from cell I2 (inclusive) downwards as far as the rows go in col A.


    So the below would change:
    From this:


    -------------- -------------- Col A ----------------------------- Col I
    Row 1 -------------- order number ---------- Schedule State
    Row 2 -------------- Order 1 ---------------------- RECEIVED
    Row 3 -------------- Order 2 ---------------------- RECEIVED
    Row 4 -------------- Order 3 ---------------------- RECEIVED
    Row 5 -------------- Order 4 ---------------------- --------------
    Row 6 -------------- Order 5 ---------------------- --------------
    Row 7 -------------- Order 6 ---------------------- --------------
    Row 8 -------------- Order 7 ---------------------- --------------
    Row 9 -------------- -------------- ---------------------- --------------
    Row 10 -------------- -------------- ---------------------- --------------
    Row 11 -------------- -------------- ---------------------- --------------
    Row 12 -------------- -------------- ---------------------- --------------
    Row 10 -------------- -------------- ---------------------- --------------


    To this:

    -------------- -------------- Col A ----------------------------- Col I
    Row 1 -------------- order number ---------- Schedule State
    Row 2 -------------- Order 1 ---------------------- RECEIVED
    Row 3 -------------- Order 2 ---------------------- RECEIVED
    Row 4 -------------- Order 3 ---------------------- RECEIVED
    Row 5 -------------- Order 4 ---------------------- OPEN
    Row 6 -------------- Order 5 ---------------------- OPEN
    Row 7 -------------- Order 6 ---------------------- OPEN
    Row 8 -------------- Order 7 ---------------------- OPEN
    Row 9 -------------- -------------- ---------------------- --------------
    Row 10 -------------- -------------- ---------------------- --------------
    Row 11 -------------- -------------- ---------------------- --------------
    Row 12 -------------- -------------- ---------------------- --------------
    Row 10 -------------- -------------- ---------------------- --------------


    Columns are always arranged by column I so the empty cell ones will always be at the bottom. It would be nice to have a solution that does not loop. Any help is always appreciated.
    Attached Files Attached Files
    Last edited by rain4u; 10-17-2011 at 06:53 PM.

Thread Information

Users Browsing this Thread

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

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