Thanks, that worked. I had to unfreeze the horizontal rows first, then it
was ok.

Glad to help!

Yes, any time you want to change this you must first 'Unfreeze' any existing
state then re-apply the 'Freeze' to your new selection.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion