Howdee! VBA userforms can be a huge help with a variety of different tasks, but can be somewhat tricky to get started with if you’ve never used them before and are new to programming. This article will serve as an introduction to VBA userforms and...
Howdee! When writing VBA code that interacts directly with data on a spreadsheet in Excel, being able to accurately define the size of your data set and iterate through rows and columns is crucial to being sure that your process runs effectively. Finding the last row...
Howdee! If you’ve ever written any VBA code, you’ve likely had to edit strings in Excel VBA. It can be challenging and more than a little frustrating, especially if you’re not familiar with the tools available to you within the framework. Have you ever had...
Howdee! Querying data over the web becomes more common every day. Almost every cloud based program has the ability to serve up its data through some sort of API. Sometimes, the data can be extracted to Excel through some sort of reporting interface within the...
Howdee! I had a lot of requests after my recent article on converting a JSON string to Excel, asking if it was possible to convert Excel to JSON. Fortunately, it is not only possible, but you can use the same library we previously covered to...
Howdee! It’s becoming increasingly more common for data to be generated in a JSON format as opposed to XML. XML was widely used for years, but recently JSON has started to become the preferred method of data exchange. Many REST APIs have the option to...
Howdee! The ability to hide columns in Excel (or rows) is not a topic that’s ground-breaking news by any means. It’s probably something you do on a regular basis. However, have you ever found yourself creating multiple views of the same report depending on the...
Howdee! Excel is a great tool for performing data analysis. However, sometimes getting the data we need into Excel can be cumbersome and take a lot of time when going through other systems. You’re also at the mercy of how a disparate system exports data,...
Howdee! There may be occasions where you need to perform an action a set number of times when writing code. This is generally called “looping”. The Excel VBA for loop is one of the most useful tools an Excel developer can learn. Being able to...
Howdee! Do you ever find yourself wishing “if only there were a function in Excel like this, I could do that”? Then this write-up is for you. Creating a custom excel function can help reduce the reliance on having multiple calculated columns or, what I...
 |
Tickets |