Using the Sum and Loop function in VBA
It has been a few years since I have had to use VBA and I have to create a macro to get the sum of column A and post it in cell (B2), and if the user adds more data it shouldn't prevent the formula from working.
Any ideas would be helpful
Thanks,
Clayton
Last edited by clayton7627; 09-12-2011 at 11:44 PM.
Try
Please Login or Register to view this content.
Martin
Hello Clayton,
Welcome to the Forum!
We are willing to help you to help you with a homework assignment but not do it for you. If we do it for you you won't learn anything. How much of the assignment can you do on your own? Which parts do you help with specifically?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks