It does seem to be an Excel limitation. I guess you have to use Copy and
PasteSpecial, Values.

--
Jim Rech
Excel MVP
"danm" wrote in message
...
|I recently moved to XP and have been forced to adjust some code that ran
fine under NT and 2000.
| The one that is driving me crazy is using rngMine.value = rngOther.value.
This has been working fine, as I said, until now. The line works until the
length of the input [rngOther] is 1606. Then I get "Run-time error '1004'
Application-defined or object-defined error." The maximum length that will
propogate under setting one range equal to another is 911. And I am doing
this across sheets [can't use fillacrosssheets as the columns on the
receiving sheet are different from the input sheet columns.]
|
| The code looks like this:
| Set rngMine = activesheet.range("a1:a5297")
| Set rngOther= Worksheets("Sheet2").range("g1:g5297")
| rngOther.value = rngMine.value
|
| HELP!
| and thank you!
| Dan