Download Update: VBA and Excel…Part 2
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.
[Update 11/16/09 12:52] I fixed the sponsor banner issue, but I’m still looking into what’s causing the IE 7 error. Despite my fondness for Firefox, I realize a large percentage of users still have IE 7 […]
Regular readers of GeoPrac are probably used to the sporadic nature of my blogging. Sometimes I add entries a couple times a week, sometimes once a week. But I wanted everyone to know why I haven’t posted in a while and why it may be kind of sporadic for the next few weeks as well.
My second daughter, Michaela (Makayla), was born on Thursday, March 13. I’ve been enjoying time at home with my family, helping my wife get adjusted to the prospect of two kids around the house! Thanks for your patience. I’m hoping that by next week’s 1-year anniversary of GeoPrac.net I’ll have a chance to write about "the state of the union" so to speak and talk a little about my goals for the site in the coming year. Thanks to all you loyal readers for sticking with me! — Randy (rockman)
Copyright © 2007-2020 by Randy Post
