Thread: Finding the last one
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Boris[_2_] Boris[_2_] is offline
external usenet poster
  
Posts: 11
Default Finding the last one
On Thu, 20 Sep 2007 10:53:53 -0700, wrote:

How would I do it for the case that I have to look at every 4th row,
not every row.

Like Joel already said, you have to move by 4, not 1:
ie.
For i = n - 1 To 2 Step -1
should be
For i = n - 1 To 2 Step -4

Regards,

B.
Reply With QuoteReply With Quote