String and Numeric Functions

You are likely already familiar with many functions–such as ROUND or TRIM–that can be applied to cell values within a worksheet. VBA also contains a number of string and numeric functions that can be applied to variables.

Excel Quick Tip: Eliminate Spreadsheet Errors with IFERROR

Spreadsheet errors appear as unprofessional and can put the integrity of your whole report into question. However, there are some circumstances where spreadsheet errors are unavoidable. By using the IFERROR statement, you can manage how errors appear on a spreadsheet.

Variables in VBA: An Overview

While the series has so far focused on VBA’s interaction with spreadsheets, there are endless opportunities for dynamic features and calculations which can occur off the spreadsheet.

Speed Test: VBA Range Object

It’s worth taking a deeper look at the Range object, as it is a central element to reading, writing, and modifying data on a worksheet. This post uses a classic speed test to time the most efficient method of interacting with a spreadsheet.

Overview of Methods and Properties of the Range Object

When coding in VBA, the range object offers a means to fully interact with cells on a spreadsheet. This is done through its object methods and properties — nearly every action undertaken in the Excel interface has a equivalent method or property in VBA.

The Range Object – Let VBA Talk to the Spreadsheet

If you’re interested in learning VBA, that means you want to write scripts that interact with a spreadsheet. The foundation of this interaction is the Range Object. The Range Object contains all the necessary features and tools to make your VBA scripts speak to a spreadsheet.

Official Launch of Excel Virtuoso

Dear Readers- I’m very excited to announce the official launch of Excel Virtuoso. This blog is dedicated to providing comprehensive guides, tips, and tricks to help professionals harness the full power of Microsoft Excel. As a business tool, nothing comes close to Excel in terms of pure flexibility and potential. …