Posted on 06/16/2017 6:48:23 PM PDT by RoosterRedux
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.