Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need large spreadsheet - can you help?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too large a spreadsheet | Excel Discussion (Misc queries) | |||
spreadsheet is too large | Excel Discussion (Misc queries) | |||
Very large spreadsheet | Excel Discussion (Misc queries) | |||
need a large spreadsheet | Excel Discussion (Misc queries) | |||
large spreadsheet | Excel Worksheet Functions |