AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() The VBA code has to be manually modified, or you just live with the sheet being called February. VBA does not adjust in the way that formulae do when you move data from one worksheet to another, insert a column, delete rows, etc.Įxample: you have a sheet called February. Sometimes writing, testing and debugging the script will take longer than using worksheet features. There are good reasons to avoid (or at least be cautious about) using VBA. It’s seductive to start thinking in VBA and head straight to the VBA editor with every task. I’ve used VBA to break the passwords on other spreadsheets. The power that’s available is almost frightening. Automating many types of reports and processes for clients.Parsing data in ways that wouldn’t have been possible through worksheet functions. ![]()
0 Comments
Read More
Leave a Reply. |