Excel VBA to Cleanse Data 3/5 - Excel Visual Basic (VBA) for Beginners

This Excel VBA for Beginners series is aimed at Excel users just starting out with code, or those who have never coded, and who are curious about it. Too often, Excel users find themselves engaged in tricky manual tasks that take up time and create stress. Data cleansing is one such task. If you have ever gone through a list of data and looked for mistakes (in the spelling of people's names, for example) then you have done a data cleansing task. It probably was not much fun! With a little coding knowledge, it is possible to dramatically speed up this kind of task, reduce the stress, and kick start your coding journey. Welcome to Excel VBA for Beginners!

DOWNLOAD the file and read the article here:

Video 1
Video 2
Video 3 (this video)
Video 4
Video 5

If you develop confidence in these areas, it won’t just save you time, it will transform the way you work with Excel spreadsheets.

I would love to hear from you – did the series help, and what are you trying to get done using Excel VBA?

🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know

For regular spreadsheet hints and tips and more on the #ExcelRevolution:

[aeopmusic]

2 Q's

1.) The CountA formula is only taking the loop down as far as the list's total count, so it's missing a few rows at end of list. Instead of counta, just use =ROW(D##)?

2.) You don't need ChrisCell.value as the variable is already set to a value?