I recommend instead managing that massive list in a String array, and
for j = ubound(strAddr) to 1
range(strAddr(j)).Value = ...

As to "This does not work" a possible culprit is that line width, which
is excessive. If anyone reads your message in a web browser it will
possibly be unpleasant to view. When you have a string that long, use
the underscore(_) for line continuation; you have the ampersand(&)
operator if you really need that long of a string. A reasonable rule of
thumb with long strings would be to line-continue after 60-70
characters.

Excel limits are at
http://office.microsoft.com/en-us/as...992911033.aspx
though I see and suspect no limit on range sizes, per se. You're
perfectly free to put a value in IV65536 and Select All so a range limit
is unlikely. Unless I'm mistaken, of course :)