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"
At the moment nothing is being returned.HTML Code:
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"
At the moment nothing is being returned.HTML Code:
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
Yes I realized that error, now the first time I run the macro nothing happens but the second time it is successful.
Also rcnt is a similar operation, so the amount of data in terms of rows is going to be identical
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks