I am suppose to debug this but I just dont know.
Copy of Backup assignment Nov 28 2012.xlsm
Sub Button1_Click() Range("C24").Value = myTotal Range("C8:C24").Select myTotal = 0 For Each myNumber In Selection myTotal = myTotal + myNumber.Value <-- here is where it's stuck atNext myNumber Range("C24").Value = myTotal Range("A1").Select End Sub
Last edited by EXLent; 12-13-2012 at 01:00 AM.
Hello amigo. How you gonna learn anything if you ask others to do your homework?
This is learning to me. Everyone has their own way of learning. Internet is the best way. Once I know the answer I can put together what is missing. Trust me, I learn alot.
Anyone else?
Perhaps change your code to
Straightforward.Range("C24").Value = WorksheetFunction.Sum(Range("C9:C23"))
Thanks mod, sorry, i'm on my non-smart phone. I will jump on pc soon. As you can see, my previous post i did use the correct code tags.
@EXLent,
Please see the forum rules about a proper thread title and code tags and adjust accordingly.
HTH
Regards, Jeff
I can code the sum easily by recording macro. I need the code as is and try to see what's wrong with it.
Kudos to JieJenn, I got confused with your recommend but you are correct. All I had to do was change C8:C23 to C9:24 because C8 is not a number.
you just answered your original question ;-)because C8 is not a number
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks