As an experiment, I decided to rewrite one of my old routines that I use a lot, but hadn't re-thought in a while — a simple sub that trims worksheet cells. I plan to do that more often in the coming weeks, because a lot of my code is old and written quick and dirty to get something done, sometimes by brute force.
Reading worksheet values into arrays
I've been exploring more with arrays and working with them in code, and I found a page in the MS KB that gives some sample code: Sample Visual Basic macros for working with arrays in Excel (FYI this page is in the VBA search engine). I was inspired in part by some of the work I'd done previously with arrays, and also some newsgroup postings about interactions between VBA and Excel.
Follow Me