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
Bookmarks