Microsoft Office Forums - View Single Post - How to use for loop in formula in VBA?

Thread: How to use for loop in formula in VBA?

View Single Post

Old

12-06-2011, 08:33 AM

tinfanide

tinfanide is offline

tinfanide uses Windows 7 64bit

Windows 7 64bit tinfanide uses Office 2010 32bit

tinfanide uses Office 2010 32bit

Office 2010 32bit

Expert

The original poster

Join Date: Aug 2011

Posts: 312

tinfanide is on a distinguished road

Default

Solved.

Code:

.Cells(x, 1).Formula = "=Sum(" & .Cells(x, 2).Address & ":" & .Cells(x, 3).Address & ")"

Reply With Quote