Restrict Merging in MSFlexGrid (VB6)

[tigertechie2]

Hi
I want to restrict Merging in MSFlexGrid. I have a grid
set up with columns of data which I want to merge as below:

Product Dept Price CostPrice
1001 1 10.00 4.90
1002 1
1003 2 10.00 4.90
1004 2
1005 3 11.00 4.90

So the columns Price and CostPrice are merged together for row 1001 and row 1002, and also for row 1003 and 1004. Therefore I want to really be able to merge the columns by the values in the Dept column.

my code is
msflexgrid.MergeCells = flexMergeRestrictColumns
msflexgrid.mergecol(Price) = True
msflexgrid.mergecol(CostPrice) = True

And I am getting merging for all identical values for the two columns:

Product Dept Price CostPrice
1001 1
1002 1
1003 2 10.00 4.90
1004 2
1005 3 11.00 4.90


Any help is gratefully accepted

Regards

Tigertechie