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.

Assigning Scope to a Range Object

By assigning scope to a range, a VBA script will know precisely where to implement the range object. This post provides a comprehensive overview of the many approaches to assigning scope.

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. …

Basic Concepts in Excel VBA

Visual Basic for Applications, usually identified as VBA, is the programming language in Microsoft Excel. This post examines some of the basic concepts and components encountered as a VBA coder.

Getting Started with the VBA Editor

One of the great things about Excel is the ability to begin writing VBA code with as few as two clicks upon opening a new workbook. This ease of access allows almost anyone to become a programmer. This post will provide a general tour of the VBA editor.