Excel VBA to Cleanse Data 2/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 (this video)
Video 3
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:

[udhelhc]

Great job Tiger! I'm a beginner in VBA and I am impressed by your explanation skills. Your courses are really helping me forward. Thanks!

[lillianasanchez]

Hello Chris, regarding this particular video, this particular lesson. When you are transforming the static reference to a dynamic one, and when you test if the particular line of code indeed selects the Range you want: min 7:53. Because it didn't select everything you needed, you added a +1 in the CountA formulae; this indeed solves the issue but what happens if tomorrow I receive another list and this time is bigger, or shorter and I want to select the range? I don't want to change the CountA on every single case, is there a way to tell CountA to count all the way down the column, do it once and it doesn't need me to manually add the extra rows? I hope you get what I mean.

[sangeethab]

What do you mean by Chris in the variable declaration