Tags » Vba

#Excel Impossibly Easy #1: Return a 1D Array from Non-Contiguous Native 3D Ranges

What if I told you that I had 2 non-contiguous 3D ranges in an Excel workbook and I wanted to return a single 1D array from those ranges. 317 more words


VBA: How to Code a Letter Frequency Chart

I recently picked up a book called “Ghost in the Wires: My Adventures as the World’s Most Wanted Hacker” by Kevin Mitnick. To be totally honest, I’d never heard of Mitnick before. 1,025 more words

Gif Guides

Office Development – Minimal Code in practice

Returning on my last ‘minimal code’ blog post, I promised to get back on this to see how this works in practice. One of my question marks I added to the post was that I wondered why the Yeoman boilerplate was using run instead of RequestContext where run passed a context parameter as opposed to the RequestContext where actively a context is requested before accessing the Word object model. 519 more words


VBA 1 Introduction to Macros in Excel


What is a macro?

A macro is a piece of programming code that runs in Excel environment and helps automate routine tasks. In a layman’s language, a macro is a recording of your routine steps in Excel that you can replay using a single button. 826 more words


Learning vba

One of the easiest ways to learn Excel macros is to record them then edit the code to see what you've recorded.

This does not however work as well with Access macros – creating macros doesn't let you into the code.