Skip to main content
4 votes

Python using generators with Excelwriter - Performance

This submission is about performance, yet it does not contain a single timing measurement. unsure how long this should really take. We expect that processing e.g. six 1 MiB workbooks should take ...
J_H's user avatar
  • 28.9k
3 votes

Snake in Excel in... VBA?

Under DrawGameBoard, when you set your game range to be Set gameRange = .Range("B2:AD31") Shouldn't it be to cell AE31? Otherwise resetting the board won'...
Jaden A. Taylor's user avatar
2 votes

Efficiently creating an array from a filtered sheet

The code in the Addendum from Tinman isn't functional. I would use the Addendum code, but instead of referencing the RelativeRowIndex, go by the ...
M4dsc1's user avatar
  • 21
1 vote

Need assistance modifying a "too large" procedure

This may not be the appropriate site for this question -- the coding path you've been going down thus far calls into question whether advice or documentation would change your practice. I will tackle ...
J_H's user avatar
  • 28.9k
1 vote

Efficiently creating an array from a filtered sheet

Inspired by M4dsc1's use of the phrase "helper column", I've come up with another approach - on the assumption that you can indeed add a helper column. The helper column (assuming we're on ...
Andi Allan's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible