Truth be told, from other posts, it sounds like he's trying to write an Excel-like cell/row/col formatting ability in VB6. And that would be quite an undertaking. Excel uses LOTS of tricks to get that done, such as a single property setting for a whole row, whole column, or some range of cells, in addition to property settings possibly for individual cells. And then, you've got the whole ZOrder problem when you have crossing properties, such as one property setting for a row, and another for a column. How is the intersection handled?

However, all I did in post #7 was attempt to answer the question posed in the OP. It seemed like an easy answer to me. I'm not sure how it would be applied to the Excel-like formatting problem, but I do believe it answers the posed question.

Y'all Take Care,
Elroy