Excel VBA – How to set a Range variable with a function
So I found myself writing some VBA code in Excel which used some Range variable types, but they were based on finding data in a range, in this case column headers. I didn’t know where the columns might be, but I knew the value the cells would hold. The problem was I didn’t always know [...]
Read More About - Excel VBA – How to set a Range variable with a function »
Excel VBA – Simple steps to speed it up!
When running VBA in Excel which comes from the macro recorder, often times it is clunky, inefficient and downright messy. Not only is this because the macro recorder is quite literal in its interpretations of your actions, but it also does not do anything to change the state in which the application is set when [...]
Read More About - Excel VBA – Simple steps to speed it up! »
Excel – Automating Tasks with the Macro Recorder – First Steps
If you haven’t noticed, I am a huge proponent of automating everyday tasks with Excel. I’ve talked about things that you can do natively (within Excel itself), but this time I’m going to talk about automating tasks in Excel from a behind the scenes standpoint by showing you how to access the programming end of [...]
Read More About - Excel – Automating Tasks with the Macro Recorder – First Steps »
Welcome to the World of Smitticisms
A brief introduction to the Witticisms of Smitty (i.e. – Smitticisms), bringing help, instruction and inspiration to all levels of Microsoft Excel users and programmers.
