I'm getting an object required error and I think it's coming from the for loop.
I'm trying to make an array out of the values of the cells in a range and then print them to make sure that I did it correctly.
Many thanks for any help. Should be a softy.
![]()
Sub lookthrough() Dim georange As Range Dim geos As Variant Range("B8").Select Set georange = Range(Selection, Selection.End(xlToRight)).Select Set geos = georange.Value For i = 1 To UBound(geos) MsgBox geos(i, 1) Next End Sub
Bookmarks