Problem while coloring cells in excel through vb
 

I am using excel 97 and vb 6.0

I have used a class in vb to create a excel sheet and to also format
it. The formating provided in the class is not enough so I have done
sme coding. Now the problem is the same code works fine with a form in
the same project but does not work in the second form .

I want to color the rows the code works fine in one form but in the
other orm coding it makes the row shaded(with dots) and do not fill
colors into it.

Please suggest what can be the possible reason.