Test file needed quickly

[Dave]

Does anyone know where I can get a very large testt excel file that has a
running macro?
What I need to do is to run several apps that will "drain" most of my
resources. I need to test another app in how it will handle low resources. I
was thinking someone might have a test file just for this reason. A large
spreadsheet that has a macro doing some calculations, at the same time while
other apps are running.

Thanks ahead for any help or suggestions.

 

[Bob I]

You realize if you fill a cell and then copy it to the rest of the
sheet, it get really big, really fast?

 

[Gord Dibben]

Run this macro on a blank worksheet.

Sub FillNums()
Dim nrows As Long
Dim ncols As Long
Dim Num As Long
Num = 1
nrows = 65536
ncols = 256
For across = 1 To nrows
For down = 1 To ncols
ActiveSheet.Cells(across, down).Value = Num
Num = Num + 1
Next down
Next across
End Sub


Gord Dibben MS Excel MVP