VBA Rubberducking

« first day (2667 days earlier) ← previous day

Duga

12:03 AM

REFRESH!

[Minesweeper] 120 Games Played. 76 Bombs Used. 15965 Moves Performed. 13 New Users

[rubberduck-vba/Rubberduck] 5 issue comments

8 hours later…

Duga

8:20 AM

[rubberduck-vba/Rubberduck] NeroGit starred us

5 hours later…

FreeMan

1:16 PM

Gah! more git issues. :(

I've been making some changes and following the commit early commit often mantra.

I just realized that I need to get back some code that I've deleted, but I can't find it.

It's obviously not in what I've currently got in my Access project. I diff that with master and don't see where it's gone missing, either.

I did a log and don't see it missing from any of my most recent commits, even though it was the last or penultimate commit I made.

What the heck have I done wrong???

I can go copy the code from my production .accdb, but this defeats the purpose of git and don't learn me nothin'

2 hours later…

Quack Exchange

3:08 PM

Q: Creating Pivot Table taking time at average vales

I need help with VBA code. I have created a macro to create pivot table automatically. But taking 15 to 20 minutes of time to complete the macro. Especially at the point of below code taking half of the time. Review Code below With .PivotFields("NTS USD ACT Previous Year") .Orientation = xlDa...

FreeMan

3:45 PM

Can you have 200,000 rows of data in Excel? Sure! You can have 1 million rows (I believe that's the max for Excel 2010 and newer). It's just going to take longer to get things done. You may be at the point where it's time to migrate your data set into an actual database instead of using Excel as a database server (which it isn't very good at). — FreeMan 1 min ago

4 hours later…