+ Reply to Thread
Results 1 to 4 of 4

Have a column return a phrase based on a number in another column

  1. #1
    Registered User
    Join Date
    05-15-2012
    Location
    Oshawa, ON
    MS-Off Ver
    Excel 2010
    Posts
    86

    Have a column return a phrase based on a number in another column

    I have created this code but it is not working properly.

    What I need to do is have column Y read "April 2012-2013 Approved Budget" if the number in column AH is = "1"

    HTML Code: 
    At the moment nothing is being returned.

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Have a column return a phrase based on a number in another column

    What is rcnt? If rcnt is a result that is less than 4, the For loop won't actually happen. You should probably change the column rcnt is looking at to be AH instead of K.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    05-15-2012
    Location
    Oshawa, ON
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: Have a column return a phrase based on a number in another column

    Yes I realized that error, now the first time I run the macro nothing happens but the second time it is successful.

  4. #4
    Registered User
    Join Date
    05-15-2012
    Location
    Oshawa, ON
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: Have a column return a phrase based on a number in another column

    Also rcnt is a similar operation, so the amount of data in terms of rows is going to be identical

+ Reply to Thread

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