Download Update: VBA and Excel…Part 2
Uncategorized
GeoPrac.net Sponsors
GeoPrac.net wishes to offer our sincere thanks for the support of all our sponsors. Please be sure to check them out and let them know you saw them on GeoPrac. And if your business is […]
Rockman's Ramblings
GeoPrac.net Celebrates 7th Anniversary!
7 years ago today, I wrote my first post for GeoPrac.net! It’s hard to believe I’ve been doing this for that long. I am grateful for all of the visitors, twitter followers, supporters, and of course sponsors that have made it possible for me to share high-quality news and articles for geoprofessionals. I look forward to another great 7 years.
Last year I highlighted a few of my favorite articles and blog posts. This year, I thought I would just go by the numbers to see what the most popular articles and posts have been over the years. Check it out.
Most Popular GeoPrac.net Content
Articles
VBA and Excel for Engineers and Scientists – Part 3
In this third and final installment of the popular VBA and Excel for Engineers and Scientists series, we will look at one of the most important techniques for extending Excel with VBA, the Range Object. I’ll show you the best way to refer to single cells, multiple cells, how to get values from them and put values back into ranges using the VBA. And we’ll program up a simple Monte Carlo Simulation example and lastly we’ll look at how to read and write to text files and to manipulate files and folders in Windows.