aztecguitars
New Member
- Joined
- Dec 21, 2016
- Messages
- 4
I'm new to VBA and don't know what search term to search for to find tutorials on what I want to do. Here it is:
I'd like to have VBA loop through numbers 1-100 and fill a particular cell in a spreadsheet that I made. I want it to wait for the calculations to process each time it fills in a new number (The sheet is huge and has a ton of different functions so takes about 10 seconds to process each time a change is made) and then save the output from another cell in the spreadsheet in a new row. I believe that VBA is able to do this, but I just can't find the correct terminology to search for in order to learn how to do it.
Thanks!
I'd like to have VBA loop through numbers 1-100 and fill a particular cell in a spreadsheet that I made. I want it to wait for the calculations to process each time it fills in a new number (The sheet is huge and has a ton of different functions so takes about 10 seconds to process each time a change is made) and then save the output from another cell in the spreadsheet in a new row. I believe that VBA is able to do this, but I just can't find the correct terminology to search for in order to learn how to do it.
Thanks!