VBA Rubberducking

Duga

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

IvenBach

7:33 AM

Hope everyone’s had a good week.

Quack Exchange

10:09 AM

0

Q: Excel VBA optimizing for large data base

I 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...

Duga

4:51 PM

[rubberduck-vba/Rubberduck] MDoerner synchronized pull request #5497: Annotate Declaration Command

[rubberduck-vba/Rubberduck] codecov[bot] edited comment on pull request #5497: Annotate Declaration Command

> # [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 +/- ##
==============================

[rubberduck-vba/Rubberduck] codecov[bot] edited comment on pull request #5497: Annotate Declaration Command

> # [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 +/- ##
==============================

Duga

5:06 PM

[rubberduck-vba/Rubberduck] build for commit a80cf791 on unknown branch: AppVeyor build succeeded

[rubberduck-vba/Rubberduck] codecov[bot] edited comment on pull request #5497: Annotate Declaration Command

> # [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 +/- ##
==============================

Quack Exchange

6:29 PM

1

Q: Looking for ways to make this macro more efficient

I 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 ...

vba excel

Transcript for