« first day (2192 days earlier)      last day (28 days later) » 

12:01 AM
RELOAD!
[rubberduck-vba/Rubberduck] 1 opened issue. 1 closed issue. 2 issue comments.
[Zomis/FactorioMods] 2 issue comments.
[Zomis/Games] 2 commits. 4 issue comments. 11 additions. 4 deletions.
[Minesweeper] Games Played: 138, Bombs Used: 76, Moves Performed: 19055, New Users: 26
 
 
8 hours later…
7:33 AM
Hope everyone’s had a good week.
 
 
3 hours later…
10:09 AM
0
Q: Excel VBA optimizing for large data base

Theresa RogersI am new to coding and need help with a code that won't complete. I suspect it is due to the size of the data set. I tested the code using a reduced data set and it processes fine. However, my actual data set is over 210,000 rows and is expected to grow. Is there a way to speed this up? Thank you...

 
 
7 hours later…
4:51 PM
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5497?src=pr&el=h1) Report
> Merging [#5497](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5497?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/37bd1bb1276854b0757e6a300e5845fc8d941ff2&el=desc) will **decrease** coverage by `0.06%`.
> The diff coverage is `54.59%`.


```diff
@@ Coverage Diff @@
## next #5497 +/- ##
==============================
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5497?src=pr&el=h1) Report
> Merging [#5497](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5497?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/37bd1bb1276854b0757e6a300e5845fc8d941ff2&el=desc) will **decrease** coverage by `0.06%`.
> The diff coverage is `54.59%`.


```diff
@@ Coverage Diff @@
## next #5497 +/- ##
==============================
 
5:06 PM
[rubberduck-vba/Rubberduck] build for commit a80cf791 on unknown branch: AppVeyor build succeeded
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5497?src=pr&el=h1) Report
> Merging [#5497](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5497?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/37bd1bb1276854b0757e6a300e5845fc8d941ff2&el=desc) will **decrease** coverage by `0.06%`.
> The diff coverage is `54.59%`.


```diff
@@ Coverage Diff @@
## next #5497 +/- ##
==============================
 
 
1 hour later…
6:29 PM
1
Q: Looking for ways to make this macro more efficient

PumpkinI have this simple macro getting data from Teradata to Excel. This process normally only takes me about 10 mins to do manually, but the macro can run for hours sometimes. So the macro seems counterproductive. But I still want to give it a shot. Could someone suggest ways to improve this? I don't ...

 

« first day (2192 days earlier)      last day (28 days later) »