I am just doing non senior level office work - Data Analyst / General Analyst type work and I figured this VBA might be useful for the future.
For now I am just accessing databases and using pretty simple commands in Excel. I have got a few books from the library. How do people like me use VBA? Do you use the record macro function and then edit the macro or do you write the VBA from scratch? Also - from what I read the analysis in Excel just using the equations works but I heard from an IT guy he said some people prefer typing codes than using Excel normally ... I can see the benefits of VBA if you want it to automate itself to non techy users like admin staff and for yourself - those repetitive tasks if you do the same work week after week etc etc .. . So for myself I can see the benefits of VBA as in more indepth defining rows and columns things like that..... b/c if I did it it would be quite manual labour and repetitive esp with the large orgs with the large spreadsheets and databases.
I like your view on this.