Thread: Offset concern
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bri[_3_] Bri[_3_] is offline
external usenet poster
 
Posts: 29
Default Offset concern

Ken - Yes, that's it exactly. I had the 'offset' and the 'end' in the wrong
places.
Thanks, Bri

"Ken Johnson" wrote in message
oups.com...
Hi Bri,
Or this?
Dim n As Integer
For n = 0 To 5
Worksheets("Sheet1").Range("A2:C" & Range("A2"). _
End(xlDown).Row).Offset(0, n * 4).Select
Next

Which I guess does what you want for 4 offsets.

Ken Johnson