Google is my go-to source for everything related to Excel, including VBA. I learned a programming language during college (Java – 2 semesters worth), and from that, I learned the basic elements of how programming works. With that base knowledge, I was able to record macros in Excel, then look at the VBA and “read” it, modifying as necessary. So, when I recorded the macro, I sorted A2:A327. But, if my data can range from 200 – 1000 records, depending on the day, then I can find where it indicates stopping in A327, and change it to A1500 (just giving myself some extra wiggle-room). After editing a few scripts, you start to understand the language more, and you're able to inject your own lines of code…or eventually, even write one from scratch.
If you have no programming knowledge at all, it might be worth considering taking an intro to programming class somewhere (community college or something online, maybe coursera has one?) to get the basics of what syntax is and how programming works. Then from there, you can expand it to any other language, since they all have a lot of similarities, though their specific rules are different. (It'd be like learning any of the Latin/Greek based languages, if you were coming from an Asian country – you've got to learn the base alphabet first, which is shared by all of them, and then you've got to learn words and sentence structure. French and Spanish might have more in common than either of them do with English, but the basics still carry over. If you want to learn Spanish but only French courses are offered, then as someone who only knows Chinese, learning French will teach you enough of the basics of Latin/Greek based languages for you to be able to learn Spanish on your own. Then if you move on to English, our sentences are structured backwards, but the words still often have similarities. Programming languages are more alike than “real” languages, since they're usually all based on English words etc., but the high-level concept is the same.)
.