Category: vba

For me, ditching the gridlines in Excel is a no-brainer. It instantly cleans up the visual landscape, especially on a screen. If you’ve ever spent a whole day, week, years, reading Excel spreadsheets you’ll agree those gridlines can become a real eyesore. And when you turn them off, it’s a miracle… everything is so much…

You can resize dynamic arrays in VBA using the redim statement and its variations. But though it seems simple enough, it’s got its tricks you need to master. Resize, but don’t delete, an array in VBA Every time you redim, your array is cleared, and you lose the information contained in it.  That is, unless…