Here is a routine that shows how to use Solver within VBA.
fooj
Convert Excel Named Range To Local Scope
Here is an Excel VBA routine for converting a named range from Workbook level scope to Worksheet level scope.
Minneapolis in June
Photos from my trip to Minneapolis in June.
My vi Cheat Sheet
My condensed version of a cheat sheet for the vi editor.
Excel VBA – RGB to HSV Color Conversion
VBA function to convert RGB values into OpenCV HSV values.
Eastern Shore
Spent the weekend visiting the Eastern Shore and Annapolis
Birthday Ride to Westminster
Took the BMW for a ride to Westminster, MD.
Minneapolis in August
Photos from my August trip to Minneapolis
Ride to Point Lookout
Took the BMW for a ride to Point Lookout.
Grandma’s Birthday
Photos from my trip to Wisconsin for my grandmother’s birthday.
Ride to Frederick MD
Took the BMW for a ride to Frederick MD for breakfast at Barbara Fritchie Restaurant.
This was the route that I took.
Grilled Cheese Sandwich with Red Onion Jam
Used a recipe from Brian Boitano. Turned out quite tasty.
Philly Beer Week
Photos from our trip to Philly for Beer Week 2013
Visual Basic/VBA – Working With Text Files
Here are a few methods for reading/writing text files.
Auto Create Excel Named Ranges
A macro for creating named ranges in a spreadsheet. The generated names are local in scope.
VBA Batch File Rename
A VBA sub routine for batch renaming/moving/copying of files.
New Zealand
Photos from our trip to New Zealand
Excel VBA Curve Fitting
These are some curve functions that can be used to generate curve fits to data that doesn’t lend itself to the built in Excel curve fits.
Site Update
I am updating my website. Please check back soon.
Smoke Hole WV
Photos from our Thanksgiving trip to Smoke Hole West Virginia.
Minnesota/Wisconsin Vacation 2012
Photos from our trip to Minnesota/Wisconsin
Minneapolis in April
Photos from my April trip to Minneapolis
Smoke Hole WV
Photos from our trip to the mountains
Minnesota/Wisconsin Vacation 2011
Photos from our trip to Minnesota/Wisconsin
Harper’s Ferry
Photos from our trip to Harper’s Ferry.
Beerthday!
Photos from our Beerthday trip to Dogfish Head Brewery and Rohoboth Beach
Minneapolis in February
Photos from my February trip to Minneapolis
Minneapolis in October
Photos from my October Minneapolis trip
Mykala In DC
Photos from Mykala’s visit to DC
Around The World
Pictures from the Around The World Party.
Minneapolis
Photos from my November trip to Minneapolis
Labor Day 2009
Photos from Emily and Pronto’s Labor Day Weekend visit
Lara and Howie’s Wedding
Photos from the trip to New York City for Lara and Howie’s wedding
Paintball!
Photos from the Lord Corporation paintball outing.