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.
I can hardly believe it, but today marks the one year anniversary of the launch of GeoPrac! It has been a good ride so far, things haven’t exactly gone quite like I planned, but when has that ever happened? I’m grateful to all of the visitors who frequent the site and particularly to the people who have contributed an article or geonews item. I intend to do a wrapup of the most popular articles/news items of Q1 2008 and a "state of the union" type post with some thoughts about where I intend to take the site in the coming year. But I’ve just been out of gas with the newborn in the house. I’ll try to get to it this weekend.
Here’s to a good first year and many more to come! Cheers!