How to use for loop in formula in VBA?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to use for loop in formula in VBA?

FAQ

Thread Tools

Display Modes

12-06-2011, 07:54 AM

tinfanide

Windows 7 64bit How to use for loop in formula in VBA?

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

How to use for loop in formula in VBA?

Code:

With Application.Worksheets("ClassroomSittingPlan")

For x = 1 To 3
''''''''''''''''''''''''''''''''''''
.Cells(x, 1).Formula = "=Sum(B"&x&":C"&x&")"
''''''''''''''''''''''''''''''''''''
Next x

End With

In the Sum formula, how can I use the for loop variable in the formula?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create slideshow that plays on loop?	Olwen	PowerPoint	1	08-25-2011 11:55 AM
music loop in powerpoint presentation	genoMU69	PowerPoint	1	06-15-2011 08:00 AM
While loop not working right	Cbrehm	Excel Programming	0	05-11-2011 11:05 AM
Continuous Loop	cksm4	Word	6	01-06-2011 09:03 PM
Outlook 2003 restart in a loop	Stegel	Outlook	0	06-29-2007 12:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:34 AM.