Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.

I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that...

Use VBA to check for nearly identical data in your Excel worksheet.

Use MS Access to find duplicates in your Excel data

In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...

Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.

Use MS Access to clean numeric fields that contain text.

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

Use Excel's formatting and data validation features to validate phone numbers

Use MS Access to clean phone numbers in your Excel data.

Adding a Visual Basic structure to your Excel file for validating data.

Use Excel tools to validate a U.S. state.

Excel data can be messy. Use MS Access features to clean it up.

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

Use an append query to add Excel data to an Access table

Tips for making your Excel data import smoothly into Access

Find cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge,...

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

Relative references vs absolute references in Microsoft Excel macros

When getting started with the Excel macro recorder, start small, and build on your successes.