View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Need large spreadsheet - can you help?

Do something easy

for i = 1 to 100000000
for rowcount = 1 to Rows.count
for colcount = 1 to columns.count

cells(RowCount,Colcount) = i
next ColCount
next forcount
next i

"DW" wrote:

I need to locate a rather large spreadsheet in which when you run the
macro it will take about 5 minutes. The purpose is for this to be a test
file in one of four are running to push the cpu usage to 95 100% max.
This is a test to see how well another program will handle the low -
none cpu usage time.

Thanks ahead of time.