I wonder how I can use a loop that has the plus/adding/+ the two columns values with each other?
Thank you!
Thread moved from the 'VBScript' forum (which is for code in .vbs files) to the 'Office Development/VBA' forum.
(2007, 2008, 2009, 2010, 2011, 2012) . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums
Classic VB FAQs (updated Oct 2010) ...Database Development FAQs/Tutorials (updated May 2011)
(includes fixing common VB errors) .......... (includes fixing common DB related errors, and [Classic VB] ADO tutorial /further steps, and [VB.Net] ADO.Net Tutorial).
Tutorial: How to automate Excel from VB6 (or VB5/VBA) .. SQL 'Select' statement formatter/checker .. Convert colour number to colour name .. FlexGrid: fill from recordset .. FlexGrid: AutoSize columns .. DB Reserved Words checker
Connection strings .. MDAC/Jet/ACE downloads .. SQL Server downloads .. MZTools (free upgrade for the VB6/VBA Editor)
Sorry!Originally Posted by si_the_geek
When you say "loop," are you looking for code to do this? If so, why not just use a formula?
u can use formula in VBA also like this, it's better than looping
it returns SUM of range A1:B100Code:MsgBox Application.WorksheetFunction.Sum(Range("A1:B100"))
Seenu
If this post is useful, pls don't forget to Rate this post.
Pls mark thread as resolved once ur problem solved.
ADO Tutorial Variable types SP6 for VB6, MsFlexGrid fast fill, Sorting Algorithms
Posting Permissions
Reply With Quote
