top of page
Search


Sum Excel by Color - Which is the Easy Way?
Summing Excel cells by color: an "easy" way and a "hard" way.

Kimberlee Martin
Mar 12, 20243 min read
27 views
0 comments


Dealing with the "Invalid Use of Nulls" Error
The Invalid Use of Nulls error message is common in VBA code when using Microsoft Access. Find out how to write code to deal with it.

Kimberlee Martin
Nov 21, 20233 min read
53 views
0 comments

VB Script vs. VBA
VB Script and VBA are two different things - do you know which is which? What will happen now that VB Script is deprecated?

Kimberlee Martin
Nov 2, 20233 min read
35 views
0 comments

Three Reasons to use Named Ranges in Excel
Here are 3 good reasons to use named ranges in Excel.

Kimberlee Martin
Oct 17, 20234 min read
21 views
0 comments


Excel Stopwatch
Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.
Kimberlee Martin
Sep 28, 20236 min read
54 views
0 comments


Detecting #N/A with VBA
Using VBA code to check for #N/A in an Excel cell. The CVErr function allows you to check for several of the "#" errors in Excel.
Kimberlee Martin
Sep 19, 20233 min read
81 views
0 comments


BEEP! An Audible Alarm in Excel
Create an audible alarm in Excel that beeps when a timer expires.
Kimberlee Martin
Sep 14, 20233 min read
14 views
0 comments


Scheduling Excel Macros with a Timer
A while back, I wrote about creating a timer in Excel. In that post, I went into detail about my failed attempts to create one, and how I...
Kimberlee Martin
Aug 8, 20234 min read
29 views
0 comments


VBA Overflow Error
The Overflow error occurs in Visual Basic when you exceed the limits of a variable's data type.
Kimberlee Martin
Mar 10, 20233 min read
108 views
0 comments


VBA: Data Type Conversion
VBA's automatic type conversion feature sometimes causes it to concatenate instead of add.
Kimberlee Martin
Jan 27, 20233 min read
19 views
0 comments


VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
Kimberlee Martin
Jan 11, 20234 min read
15 views
0 comments


VBA: Three Ways to Handle Text in Numeric Fields
Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.
Kimberlee Martin
Jan 3, 20235 min read
10 views
0 comments


Doubles, but No Troubles
Use VBA to check for nearly identical data in your Excel worksheet.
Kimberlee Martin
Dec 19, 20224 min read
20 views
0 comments


Auto-replace Text in Excel Cell with VBA
In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...
Kimberlee Martin
Dec 6, 20222 min read
25 views
0 comments


Parse Phone and Extension with VBA
Last week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file...
Kimberlee Martin
Nov 28, 20226 min read
19 views
0 comments


Validation Harness in Excel VBA
Adding a Visual Basic structure to your Excel file for validating data.
Kimberlee Martin
Nov 18, 20229 min read
47 views
0 comments


Debugging VBA without Line Numbers
I wrote a post several years ago about adding line numbers to your VBA code. To this day, it remains my post popular post ever. Why? It’s...
Kimberlee Martin
Nov 7, 20223 min read
9 views
0 comments


Dynamic Highlighting in Excel
Find cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge,...
Kimberlee Martin
Jun 7, 20223 min read
28 views
0 comments

Temporary Watermark in Excel
Adding a Watermark to an Excel document only when printing
Kimberlee Martin
Jan 18, 20215 min read
45 views
0 comments


Option Explicit
If you’ve ever written VBA code in Excel, Access, or any of the other products in the Microsoft Office suite, you may already be familiar...
Kimberlee Martin
Apr 17, 20173 min read
23 views
0 comments
CATEGORY
ARCHIVE
bottom of page