Using Office 2003 and Windows XP;

I have a sheet containing some 50 rows of merged cells: "G12:H12";
"G13:H13", etc. note: G to H

I want to shade them using something like:

Range(msaGLADAddress(iX)).Interior.ColorIndex = 6

Where msaGLADAddress(iX) is a module level string array containing the
address: "G13:G54"; but I get an error: cannot set the color index. Is there
a way around this? How can I shade these cells without changing the cell
address in the array?

Thanks much.