Posted on 06/16/2017 6:48:23 PM PDT by RoosterRedux
I have been learning VBA for Excel for a few weeks. Have used Excel for years (I am an adept mathematician) but haven't taken the time to learn the language which supports it.
I have been searching videos that teach this subject and, so far, this is the best I have found.
I welcome advice from Freepers who know better than me.
My professional career grew up in the period prior to excel, but not prior to computers.
If I had Excel in grad school, I would still be in the basement running numbers.
You can use Google search, just enter"
"Excel macro" and some specific action you want the macro to do, such as "copy rows to new sheet" or "find matching rows", or "connect to database".
Very few users even know about the vast potential of Excel using the macros.
Look up "nesting functions" (or just click on the link)...it's amazing what can be done with Excel.
That said, I keep hearing that it is better to write macros in the VBA editor than on the surface of Excel. Apparently cleaner, more functional, and more durable.
But don't listen to me, I am just learning VBA (after many years of using Excel in work and in analyzing the market and companies traded).
The in-cell formulas are useful, but have their limitations.
The VBA macros are a full-blown programming language, suitable for all the business processing and hobby stuff I've needed.
Engineering stuff might need some other applications, but I wouldn't know.
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.