Timeline for Speed up before/after refresh subs
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 14, 2022 at 7:46 | answer | added | AcsErno | timeline score: 1 | |
| Jan 4, 2022 at 16:41 | comment | added | HackSlash | I see, you can also protect cells that you don't want people to edit. support.microsoft.com/en-us/office/… | |
| Jan 3, 2022 at 14:36 | comment | added | sullivan.syd | @HackSlash the formulas are static, but some of those cells will have been overridden with manually entered data. The spreadsheets are being sent out to employees that don't work with Excel in too much depth, so repopulating them via VBA was sort of to prevent users from clearing out the formula and it not autofilling back in! | |
| Dec 30, 2021 at 19:07 | comment | added | HackSlash | Those formulas at the end appear to be static. Can they be populated directly in a table once instead of added programmatically? | |
| Dec 30, 2021 at 19:05 | comment | added | HackSlash | The most expensive operation appears to be the for each loops. Maybe you can achieve this a different way, like formatting the cells. | |
| Dec 29, 2021 at 7:30 | answer | added | ljdyer | timeline score: 3 | |
| Dec 28, 2021 at 17:25 | comment | added | 200_success | Welcome to Code Review. What does this code accomplish? Please tell us in detail, and provide some sample data, so that we can understand the task and give you better advice. | |
| S Dec 28, 2021 at 16:20 | review | First questions | |||
| Dec 28, 2021 at 18:29 | |||||
| S Dec 28, 2021 at 16:20 | history | asked | sullivan.syd | CC BY-SA 4.0 |