I don't think so.
This worked for me:
Option Explicit
Sub testme()
ActiveSheet.Cells.Value = 1
End Sub
All 16,777,216 were changed to 1.
You may want to be a little more specific.
Joseph Czapski wrote:
Hi. I've run into Excel 2003 complaining that I'd exceeded 2,560 cells. Is
there a limit to how many cells whose values you can insert individually
programatically via Excel's object library? Thanks.
Joe Czapski
Boston, Mass.
--
Dave Peterson