Welcome to the home of the Macro Man! This is a little corner of the internet for me write just about anything, covering topics such as forum etiquette, emerging technology and the world of programming (including macros of course!).

I also have a separate site for a collection of photographs that I’ve taken, I’m not a photographer by any means but I like to capture things that make me smile in photo form for a rainy day.

If you would like to use any of the content on this site, including photographs, please get in touch using the contact form below.



VBA Variables

I often see a lot of confusion around variables in VBA, especially when people see things like this: Run-time error ‘6’: Overflow and don’t understand why their code isn’t working. For all of you “TLDR” types, here’s a quick table of the more common data types:


Want to ask a question or just say “Hi”? Drop me a line using the contact form below!