I have a huge csv of data(product import list from a supplier) that I need to work some data magic on and I decided to tackle the problem with VBA in Excel, since doing it in any other way would be a pain in the ass and possibly take too long. I've never worked with VBA, but so far it seems pretty damn simple and I've been able to get the basics down in about half an hour.
Anyone have a good resource site for VBA? I'm basically looking for a cheatsheet/reference site that has all the most essential or most common VBA functions/commands. Googled around for a bit, but nothing good came of it, I've just been Googling every command or function that I realize I need.
Anyone have a good resource site for VBA? I'm basically looking for a cheatsheet/reference site that has all the most essential or most common VBA functions/commands. Googled around for a bit, but nothing good came of it, I've just been Googling every command or function that I realize I need.