Thread: How does .offset(i, counter) work?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
  
Posts: 102
Default How does .offset(i, counter) work?
Hi everypne,

How does the following piece of code work:

With Range("G2")
For i = 1 To 30
.Offset(i, ModelCounter) = Range("Picked").Cells(i)
Next
End With

In particular the offset line please!

Thanks,
Mike

Reply With QuoteReply With Quote