VBA Text Formatting And Font Formatting

Formatting text is one of the most powerful ways you can improve the adoption and usability of your Excel files. Excel has robust text formatting and font capability and these are available in VBA. Writing a macro that can insert text with certain text attributes and fonts or manipulate existing cells formatting can come handyContinue reading “VBA Text Formatting And Font Formatting”

Excel VBA Loop Through Rows, Cells, or Columns

Using VBA to loop through rows, cells and columns can transform the way you handle your spreadsheets. In this post, I’ll cover a few ways you can achieve this with some helpful examples. The key to looping through any of these objects is the Range object. The Range object represents a cell, or a selectionContinue reading “Excel VBA Loop Through Rows, Cells, or Columns”

How To Use Excel VBA Find, With Example!

Finding a value in a sheet can be very handy when using Excel VBA, within macros or sheet code. Luckily, VBA has a Find function that you can call on a Range, which can find values in the sheet. It also allows you to configure how the function will search for whatever you’re looking for.Continue reading “How To Use Excel VBA Find, With Example!”

The Right Way To Do Last Modified Date In Excel (Without Using TODAY)

Excel still holds an important place in a lot of the business software world. Underneath its simple spreadsheet is a powerful tool with its own robust coding language (Visual Basic) and frameworks. I recently ran into an interesting problem when I was working on an Excel project: How do I store the last modified dateContinue reading “The Right Way To Do Last Modified Date In Excel (Without Using TODAY)”