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...
Search
Kimberlee Martin
- 6 days ago
- 4 min
Validating Numeric Fields in Excel
Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
50
Kimberlee Martin
- 7 days ago
- 5 min
Using Access to Clean Excel Data, Part 3
Use MS Access to clean numeric fields that contain text.
20
Kimberlee Martin
- Nov 28
- 6 min
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...
50
Kimberlee Martin
- Nov 23
- 6 min
Validate Phone Numbers in Excel
Use Excel's formatting and data validation features to validate phone numbers
20
Kimberlee Martin
- Nov 21
- 6 min
Using Access to Clean Excel Data, Part 2
Use MS Access to clean phone numbers in your Excel data.
120
Kimberlee Martin
- Nov 18
- 9 min
Validation Harness in Excel VBA
Adding a Visual Basic structure to your Excel file for validating data.
40
Kimberlee Martin
- Nov 14
- 5 min
Using Access to Clean Excel Data, Part 1
Excel data can be messy. Use MS Access features to clean it up.
100
Kimberlee Martin
- Nov 7
- 3 min
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...
30
Kimberlee Martin
- Nov 4
- 7 min
Appending Excel Data to an Access Table
Use an append query to add Excel data to an Access table
70
Kimberlee Martin
- Oct 25
- 6 min
Importing Excel Data to Access
Tips for making your Excel data import smoothly into Access
160
Kimberlee Martin
- Jun 7
- 3 min
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,...
170
Kimberlee Martin
- Apr 20
- 6 min
One Click to Run Your Macro
I’ve written a couple of blogs lately about creating Excel macros. In a related topic, today I’m going to talk about one of the easiest...
170
Kimberlee Martin
- Mar 21
- 3 min
It's All Relative
Relative references vs absolute references in Microsoft Excel macros
70
Kimberlee Martin
- Mar 14
- 2 min
Where to Start with the Excel Macro Recorder
When getting started with the Excel macro recorder, start small, and build on your successes.
80
Kimberlee Martin
- Jun 9, 2021
- 4 min
Making the Most of Excel – Data Validation
Last week I discussed using Excel effectively, in order to ensure it best serves your small business. I’m going to expand on that today,...
130
Kimberlee Martin
- Jun 3, 2021
- 4 min
Making the Most of Excel
Ideas for maximizing your use of Microsoft Excel
130
Kimberlee Martin
- May 26, 2021
- 3 min
Check Marks in Excel
Excel is a great tool for helping you stay organized, and many people create checklists in Excel for just that purpose. I’ve got a...
200
Kimberlee Martin
- Apr 19, 2021
- 3 min
Adding an "Always On Top" panel in Excel
There’s a cool feature in PowerPoint that allows you to see all of your slides in sequence, move them around, and double-click to edit...
180