How to specify a general row to start a for loop

[mumair]

So right now I have a for loop like this:

Please Login or Register  to view this content.

lr is a long defined as

Please Login or Register  to view this content.

I want i to be defined as something like that, so it is general and not referring to a specific row. Any ideas?

[protonLeah]

No. "i" is not the problem, the 24 is. You need:
For i = StartRow to EndRow (lr in your case). However, it's up to you to determine the starting row base on some criteria like a name or date, etc. that can be found with a .Find or some other calculation.