I've printed some sample code that I liked, too. But after a little bit, I ran
out of paper <bg.

You may want to save your ink and invest in a book (or two).

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's books are very good to start.

See if you can find them in your local bookstore/internet site and you can
choose what one you like best.

Matt wrote:

Right...

Off topic: Just reviewed the Peterson sort using shapes to create
clickable column headers..nice.
(I've never use the application.caller)

Sort of On Topic: I find that printing off code and staring at it for
a whiles helps me grasp it alot better.

Dave Peterson wrote:
I either steal that .find code from another location or I record a small macro
when I do it manually (or just use VBA's help if I'm really industrious).

And I like to specify the after:= parm, too. Sometimes, I'll use:
..., after:=cells(1), SearchDirection:=xlPrevious, ...
to find the last one in the range.



Matt wrote:

<<snipped

Thanks again...I studied your code a bit and it definately seems more
complete...
memorizing the .find params and understanding them seems worth the
effort
One of the things I noticed is that you use the After:=.Cells
(.Cells.Count)
This pushes the .find to start at cell 1 instead of cell 2 which based
on the help file seems to be
the default.

--

Dave Peterson

--

Dave Peterson