What are the available ways to create Nested Loops in VBA?

[excelos]

Hello

I want to create this nested loop:

For Each cell In Range("a1:a10")
Cell.value = 1*(For i = 0 to 10 next i)
Next cell

Any idea how it could be structured?

Also are there any other forms/types of nested Loops and what are the possible structures?

Thanks!

 

[excelos]

Thanks, where can I find the documentation for the Cells(i, 1).Value please? Particularly the Cells(i, 1).

 

[Fluff]

Just search the net for "Cells(i, 1).Value", plenty of sites come up.

 

[excelos]

I actually think it is mentioned in: Cell Object

By the way, I think:
Cells(i, 1).Value = (i + 4)*100
should be:
Cell(i, 1).Value = (i + 4)*100

Do you agree?

 

[MARK858]

Do you agree?

No

 

[Fluff]

No

Agreed

 

[excelos]

No

Where is that documented in Cells Collection Object ?

 

[Fluff]

Why are you linking to documentation for Word?

 

[MARK858]

Try the 2 codes below in Excel (see fluff's previous post), and tell us what happens
Documentation link

Sub FillSequence()
  Dim i As Long

  For i = 1 To 10
    Cell(i, 1).Value = (i + 4) * 100
  Next i
End Sub

Sub FillSequence()
  Dim i As Long

  For i = 1 To 10
    Cells(i, 1).Value = (i + 4) * 100
  Next i
End Sub

 

[Rick Rothstein]

And then, of course, you don't always need a loop ...

Sub FillSequence()
  [A1:A10] = [100*ROW(5:14)]
End Sub