LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
final return! via135 Excel Worksheet Functions 5 January 11th 08 11:00 AM
Macro - Final ciba1234 Excel Programming 1 September 15th 05 09:14 PM
Final Question Himszy Excel Programming 3 December 31st 04 08:30 PM
some final help rbekka33[_19_] Excel Programming 1 September 23rd 04 01:19 PM
Help Finding the Final Row No Name Excel Programming 7 May 21st 04 03:13 AM


All times are GMT +1. The time now is 03:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"