Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bootstrapping in Excel
Hey guys,
I'm pretty much brand new to VBA and I'm trying to figure out how to bootstrap in Excel and run around 10,000 simulations. I'd like to do it without using @Risk or Monte Carlo. I have a macro now that essentially simulates one set of data, copies it into another cell, and repeats a specified amount of times. But since the end of the macro tells it to rerun the macro, the macro returns an "out of stack space" error after 188 simulations. Is there any way to get around this or to run simulations in Excel without using MC or @Risk? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bootstrapping in Excel
On Jul 6, 12:45 am, wrote:
Hey guys, I'm pretty much brand new to VBA and I'm trying to figure out how to bootstrap in Excel and run around 10,000 simulations. I'd like to do it without using @Risk or Monte Carlo. I have a macro now that essentially simulates one set of data, copies it into another cell, and repeats a specified amount of times. But since the end of the macro tells it to rerun the macro, the macro returns an "out of stack space" error after 188 simulations. Is there any way to get around this or to run simulations in Excel without using MC or @Risk? Hi Joshua Insert a new Module Insert a procedu call it DoMacro Sub DoMacro Dim iCount as long For iCount 1 to 10000 Next |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bootstrapping in Excel
On Jul 6, 12:45 am, wrote:
Hey guys, I'm pretty much brand new to VBA and I'm trying to figure out how to bootstrap in Excel and run around 10,000 simulations. I'd like to do it without using @Risk or Monte Carlo. I have a macro now that essentially simulates one set of data, copies it into another cell, and repeats a specified amount of times. But since the end of the macro tells it to rerun the macro, the macro returns an "out of stack space" error after 188 simulations. Is there any way to get around this or to run simulations in Excel without using MC or @Risk? (let's try that again and don't bash the down arrow just cause iTunes got stuck...) Hi Joshua In the VB editor: Change your macro "yourMacro" so it doesn't call itself. Double-click the 'ThisWorkbook' object Drop the (General) combobox to show 'Workbook' Drop the Procedure combobox to show 'Open' Enter this code: Dim iCount as long For iCount = 1 to 10000 Call YourMacro DoEvents Next Close and open your workbook to run the new macro HTH David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bootstrapping in Excel
On Jul 5, 11:03 am, wrote:
On Jul 6, 12:45 am, wrote: Hey guys, I'm pretty much brand new to VBA and I'm trying to figure out how to bootstrap in Excel and run around 10,000 simulations. I'd like to do it without using @Risk or Monte Carlo. I have a macro now that essentially simulates one set of data, copies it into another cell, and repeats a specified amount of times. But since the end of the macro tells it to rerun the macro, the macro returns an "out of stack space" error after 188 simulations. Is there any way to get around this or to run simulations in Excel without using MC or @Risk? (let's try that again and don't bash the down arrow just cause iTunes got stuck...) Hi Joshua In the VB editor: Change your macro "yourMacro" so it doesn't call itself. Double-click the 'ThisWorkbook' object Drop the (General) combobox to show 'Workbook' Drop the Procedure combobox to show 'Open' Enter this code: Dim iCount as long For iCount = 1 to 10000 Call YourMacro DoEvents Next Close and open your workbook to run the new macro HTH David Thanks a lot for the help, guys. It works now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|