ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need large spreadsheet - can you help? (https://www.excelbanter.com/excel-discussion-misc-queries/189907-need-large-spreadsheet-can-you-help.html)

DW[_2_]

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.

joel

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.



All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com