Results 1 to 4 of 4

Macro Loops through 10 rows, find's next cell value > 0 places X in adjacent cell & Stops.

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    7

    Macro Loops through 10 rows, find's next cell value > 0 places X in adjacent cell & Stops.

    Hi All,

    I am looking to create a macro that will loop through a column of at most 10 rows. The macro needs to identify the next number > 0 in the column, set the cell value of the adjacent cell to "X" then stop. When the macro is executed again, it needs to delete the "X" it just created prior to identifying the next number > 0 and placing an "X" in it's corresponding adjacent cell. If the macro has reached the bottom of the range it needs to go back to the top of the range and begin again.

    I'm feeling pretty stuck here and could use some guidance. Attached please find the template for reference.

    Thanks in advance,

    MIACG

    X_Loop.xlsm
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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