Dorin --

I'm not familiar with AutoFilter in Excel, but from browsing the documentation it looks like it's a way for the user to select rows to display based on selection criteria.

As it happens, I already have that feature ... as part of the default right-click pop-up menu for any grid, the user can select based on the values in the column clicked on. The selection is sensitive to the data type of the column (character, logical, numeric and dates, as I recall.) This is handled by temporarily changing the filter for the grid, of course.

These can be grouped to allow selections between multiple columns. Handy feature for competent users.


>>Dorin --
>>
>>Yeah, I think getting the data grid for the totals will be quite straightforward.
>>
>>Aligning it will be a little tricky, though, since I think it will have to overlay the lower part of the header of the real grid -- it can't overlay the first row, of course, so I believe I'll have to increase .headerheight appropriately. (A little bit of pixel counting, similar to what you did).
>>
>>Am looking forward to the opportunity to dig into your code to understand how you take care of horizontal scrolling.
>>
>>If I understand it, I have another application for it as well -- "super" column headings. I've always wanted to be able to place a "column heading" that spans part of the header for two or more columns. "YTD" might be a super-heading, for instance, for a couple of adjacent columns that all have YTD info in them. I hadn't implemented this because I could not get the horizontal alignment correct, but it appears that you've conquered this problem.
>>
>>Jim
>>
>
>Or another application, something similar to "Auto Filter" in excel. I plan to design something like this, but I don't have enough time for it now.
>
>Dorin