Timeline for Housing a summary of information in a data file
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 10, 2020 at 13:24 | history | edited | Community Bot |
Commonmark migration
|
|
| Aug 23, 2018 at 22:46 | comment | added | Raystafarian | If you pull your entire range into an array, you can just use the array with iterating through it with a single variable. Or split it into separate arrays and use those per "row" | |
| Aug 23, 2018 at 20:39 | comment | added | Dan | Raystafarian - Back to variables discussion. Is there an easier way to handle/group variables. Like TalkTime (not to mention the other 15 columns I will need to reference) is going to have a range, along with a column #. So instead of creating a talkTimeRange as range and a talktimecolumn as double, I was hoping there would be an easier way to keep all the talktime variables organized. I was looking at classes/objects but that stuff goes over my head. My final code has 63 variables. I plan on optimizing the code now that it's done. | |
| Aug 19, 2018 at 22:25 | comment | added | Raystafarian | Formulas are virtually never quicker than VBA in calculation unless it's written badly. On the other hand, if you need the formulas in the sheet at the end, sometimes it makes sense to turn off calculation, generate the formulas and then turn it back on. | |
| Aug 19, 2018 at 21:19 | comment | added | Dan | I'm pretty advanced with Excel formulas, so what I found to be a lot quicker than the loops was paste in the formula into the first cell, then copy and paste special formulas into the range. Keep in mind the above isn't my full code. so I was doing loops for Call Length and to build identifiers (concatenate to cells). It was taking way too long, but now it's a split second to copy/paste the formulas. | |
| Aug 18, 2018 at 21:53 | comment | added | Dan | Raystafarian - thanks a ton. I will definitely look through when optimizing the code. I have had no formal education so I've taught myself and like I mentioned in the beginning, I code based on how I would do it manually with lots of loops and nested IFs. Again, thanks for tips, I appreciate the time and effort you put into your response. | |
| Aug 18, 2018 at 4:54 | history | undeleted | Raystafarian | ||
| Aug 18, 2018 at 4:54 | history | edited | Raystafarian | CC BY-SA 4.0 |
added 4444 characters in body
|
| Aug 18, 2018 at 4:35 | history | deleted | Raystafarian | via Vote | |
| Aug 18, 2018 at 0:04 | history | answered | Raystafarian | CC BY-SA 4.0 |