+ Reply to Thread
Results 1 to 2 of 2

Help modifying existing VBA code

  1. #1
    Registered User
    Join Date
    08-27-2008
    Location
    Oregon
    Posts
    3

    Help modifying existing VBA code

    Hello,

    I have the following existing code that find the first eligible row, and to
    start filling in data from an array, looking for the next eligible row (skip the row with "ASC" written in column I) after filling in 8 columns (I:N) and looping as many times as is specified in the call from the main routine.

    I would like to modify the code so that instead of skip the entire row if column I is "ASC", but only skip the cell with "ASC" instead, but still in fill the data without "ASC" on the same row.

    Old code sample data:
    A H I J K L M N O P
    Line# Mod 1300 1300 1500 1500 1700 1700 1100 1100
    001 300 ASC
    002 100 x x x x x x x x
    003 200 x x x x x x x x

    skip row 2 with line# 001 cause "ASC" is in column I2 so skipping cell J2
    thru N2). Where x is data that the macro fill in.

    New code wanted:
    A H I J K L M N O P
    Line# Mod 1300 1300 1500 1500 1700 1700 1100 1100
    001 300 ASC x ASC x x x x ASC
    002 100 x ASC x x x x x ASC
    003 200 x x x x x x x x

    it does not skip row 2 with line# 001, but rather fill in the missing cell
    (J2, L2, M2 and N2) without "ASC" in the cell.

    My code is too long to list here.
    Last edited by VBA Noob; 08-27-2008 at 04:55 PM.

  2. #2
    Registered User
    Join Date
    08-27-2008
    Location
    Oregon
    Posts
    3

    Code attached

    Attached is my existing code.

    Any help is appreciated.
    Attached Files Attached Files

+ 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. Format Canadian Postal Code on Entry
    By Gos-C in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 03-24-2019, 04:20 PM
  2. Imported VBA code not working....
    By HuskerBronco in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-02-2008, 05:57 PM
  3. Code Execution Degrades Over Time
    By KDT in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2008, 04:28 PM
  4. Excel closes when using VBA to write VBA code
    By btoback in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2007, 03:42 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