+ Reply to Thread
Results 1 to 3 of 3

repeat macro based on a cell value

  1. #1
    Registered User
    Join Date
    11-14-2014
    Location
    Kansas
    MS-Off Ver
    2013
    Posts
    4

    Lightbulb repeat macro based on a cell value

    I am looking to repeat a macro I have based on the value in column R. The value in column R changes from row to row and If it has the value of 1 I would like my macro to not be used and move to the next row. I hope this makes sense and if anyone can help me with some coding I would greatly appreciate it.

    This is the code I have:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by cmedved07; 12-18-2014 at 03:14 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Re: repeat macro based on a cell value

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    11-14-2014
    Location
    Kansas
    MS-Off Ver
    2013
    Posts
    4

    Re: repeat macro based on a cell value

    I have attached a sample file above. Thank you for the response and this will help me out tremendously. Let me know if you need more information.

+ 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. repeat macro based on a cell value
    By cmedved07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2014, 12:09 PM
  2. Macro or Eqn to Repeat Formula "X" times based on Number in Cell
    By waltheaj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2013, 12:24 PM
  3. How to repeat a macro x number of times based on a value in a cell
    By gypsyhotelier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2011, 05:11 PM
  4. Replies: 0
    Last Post: 08-03-2011, 01:58 PM
  5. Repeat values based on number count (without macro)
    By ibexcel in forum Excel General
    Replies: 7
    Last Post: 12-17-2009, 06:35 AM

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