VB Excel, How to make a loop?

Question

here is what i want:

Assume I have 2 ranges of data A and B. B is calculated from a series of calculation included values of range A. I want a loop of 20 times to put B into A and calculate B again. How do I do this?

Thanks in advance

brettdj · Accepted Answer · 2012-02-25 10:18:39Z

1

Here is a very simple VBA loop that creates a 20 x 20 matrix. It will help you understand looping with two number ranges.

Sub looptutorial() Dim a As Integer, b As Integer ThisWorkbook.ActiveSheet.Select For b = 1 To 20 For a = 1 To 20 Cells(a, b).Select Selection.FormulaR1C1 = a * b Next a Next b End Sub

edited Feb 25, 2012 at 10:18

brettdj

55.9k16 gold badges120 silver badges178 bronze badges

answered Dec 5, 2011 at 10:05

Saidur Rahman

4203 gold badges6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

brettdj Over a year ago

'Select' should be avoided in VBA.

Saidur Rahman Over a year ago

@brettdj yes thanks for the comment. I wanted to make it intuitive how the code worked when the op stepped through the code. I agree with you.

Collectives™ on Stack Overflow

VB Excel, How to make a loop?

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related