improve processing speed- individual patient simulation purely in VBA

[rbkh79]

Hello- I have an individual patient simulation model that I have built in excel.
In order to improve the processing speed I have been told that there is a way to have all of the simulations run in VBA and not documented line by line in excel. I was told that there is also a way to print a report of the VBA activities.

So my questions are:
1) How do I have the code run purely in VBA?
2) How can I print a report of the VBA simulation, if needed?

Thank you!!

 

[rbkh79]

To clarify, what I mean is that the outputs for each patient are temporarily stored in VBA as opposed to line by line in the excel workbook.

 

[sericom]

You place a range into an array, then process the array, eg

    Dim arr() As Variant
    arr = Range("A1:C4")
    For r = 1 To UBound(arr, 1)
        For c = 1 To UBound(arr, 2)
            Debug.Print arr(r, c)
        Next
    Next