View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default 2,560 cell limit???

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