I'm not sure. You could try a new posting in .programming.

But how about the sub and the sample offered by JB (Jacques) in response to
your multi-post* in .misc?
*pl refrain from doing this

Why not check it out and reply further to him there?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"raphiel2063" wrote in message
...
Doh! Do you know if it would be possible to have a macro which indexes the
whole thing and then sort it by type (as you can do with a formula), then
have the macro remove the empty columns? I'd need it to reset afterwards
so
multiple 'reports' could be made.