+ Reply to Thread
Results 1 to 4 of 4

Help Cleaning Up Repetitive Code

  1. #1
    Forum Contributor
    Join Date
    09-09-2013
    Location
    California, USA
    MS-Off Ver
    MS 365 Subscription
    Posts
    130

    Help Cleaning Up Repetitive Code

    I have an if statement that I want to use from C8:C100. Right now I have an if statement for each cell. How can I write this for a range instead of an individual cell?

    Please Login or Register  to view this content.
    And so on and so on......

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Help Cleaning Up Repetitive Code

    Try this.

    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Help Cleaning Up Repetitive Code

    Another way:

    Please Login or Register  to view this content.
    Last edited by shg; 07-09-2015 at 03:50 PM.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Contributor
    Join Date
    09-09-2013
    Location
    California, USA
    MS-Off Ver
    MS 365 Subscription
    Posts
    130

    Re: Help Cleaning Up Repetitive Code

    Quote Originally Posted by skywriter View Post
    Try this.

    Please Login or Register  to view this content.
    This worked great!!! Thank you

+ 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. [SOLVED] repetitive code, possible shortening
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-19-2014, 02:41 PM
  2. Repetitive Code VBA macro
    By schenck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2013, 02:04 AM
  3. Consolidating repetitive code
    By ChristineJ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2012, 11:31 AM
  4. Loop for repetitive code
    By jackandjill in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-18-2010, 10:18 PM
  5. Repetitive VBA code
    By HuskerBronco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-24-2007, 03:10 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