Editing a for each next loop
 

Hi
How do I instead of selecting the range B6:Bb14 below tell excel to loop
starting from b6 and continue down till the cell in col B is empty?

?Sub PasteData()

Dim r As Range

For Each r In Worksheets("Makron").Range("B6:B14")
GetPortfolioData Portfolio:=r.Value
Next

End Sub

Editing a for each next loop
 

Ah, that worked! Great!

Many thanks!




"Gary''s Student" skrev:

You can test for empty in the loop:

Sub PasteData()

Dim r As Range

For Each r In Worksheets("Makron").Range("B6:B14")
If IsEmpty(r.Value) Then
Exit For
End If
GetPortfolioData Portfolio:=r.Value
Next

End Sub
--
Gary''s Student


"sverre" wrote:

Hi
How do I instead of selecting the range B6:Bb14 below tell excel to loop
starting from b6 and continue down till the cell in col B is empty?

?Sub PasteData()

Dim r As Range

For Each r In Worksheets("Makron").Range("B6:B14")
GetPortfolioData Portfolio:=r.Value
Next

End Sub