View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default Final Value, For / Next Loop

Nothing is mentioned in the remarks for the For / Next Loop about NOT
being able to change the final value of the counter.

In my application I have a set number of rows per "page" in a manual, and I
want to skip the first row of each page.

I have proven that the following code does NOT work when crossing
this "first" row boundary. I've coded a work around using do until ....
by maybe I'm doing something wrong. Any comments?

For XX = TargetRow To FRow
If XX Mod RteRowsPPg < 1 Then Cells(XX, RigCol).Interior.ColorIndex =
Salmon Else FRow = FRow + 1
Next XX ' note Salmon is set to a number via a Const statement.

Thanks,
Neal Z.



--
Neal Z