Microsoft KB Archive/239573

From BetaArchive Wiki
Knowledge Base


WD97: Cannot Set More Than One Property on Merged Cell Using Range Object

Article ID: 239573

Article Last Modified on 1/25/2007



APPLIES TO

  • Microsoft Word 97 Standard Edition



This article was previously published under Q239573

SYMPTOMS

When you set more than one property of a merged cell within a Word table through a Range object of a Cell object, none of the changes is applied to the merged cell.

WORKAROUND

To work around this problem, refresh the Cell object and Range object references between the setting of a single property on a cell within a table with merged cells. As illustrated in the following example code:

Sub BuildTable()
  ' Create the table with merged cell
  ActiveDocument.Tables.Add Range:=Selection.Range, NumRows:=4, NumColumns:=4
  With ActiveDocument.Tables(1)
        .Cell(Row:=1, Column:=3).Merge _
        MergeTo:=.Cell(Row:=2, Column:=3)
       .Cell(Row:=2, Column:=1).Merge _
        MergeTo:=.Cell(Row:=4, Column:=2)
  End With
  shadecell
End Sub

Sub shadecell()
  Dim i As Integer
  Dim mycellrange As Range
  Dim startrange As Range
    For i = 1 To ActiveDocument.Tables(1).Range.Cells.Count
        Set mycellrange = ActiveDocument.Tables(1).Range.Cells(i).Range
        Set startrange = ActiveDocument.Range(Start:=mycellrange.Start, _
          End:=mycellrange.Start)
        With startrange.Cells.Shading
          .BackgroundPatternColorIndex = wdBrightGreen
        End With
        'MsgBox "cell = " & i
    Next i
    For i = 1 To ActiveDocument.Tables(1).Range.Cells.Count
        Set mycellrange = ActiveDocument.Tables(1).Range.Cells(i).Range
        Set startrange = ActiveDocument.Range(Start:=mycellrange.Start, _
          End:=mycellrange.Start)
        With startrange.Cells.Shading
          .Texture = wdTexture25Percent
        End With
    Next i
    For i = 1 To ActiveDocument.Tables(1).Range.Cells.Count
        Set mycellrange = ActiveDocument.Tables(1).Range.Cells(i).Range
        Set startrange = ActiveDocument.Range(Start:=mycellrange.Start, _
          End:=mycellrange.Start)
        With startrange.Cells.Shading
          .ForegroundPatternColorIndex = wdAuto
        End With
    Next i
End Sub
                

RESOLUTION

To resolve the problem described in this article, obtain and install the latest Microsoft Word 97 update from the following Microsoft Web site:

IMPORTANT NOTE: Microsoft Word 97 post-service release fixes are cumulative. The latest update contains all of the fixes since Service Release 2. If you install the latest update for Word 97, you do not need to install any other updates after Service Release 2.

For additional information about the fixes included in the latest update for Word 97, click the article number below to view the article in the Microsoft Knowledge Base:

265374 WD97: Post Service Release Fixes for Word 97




STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbhotfixserver kbqfe kbdownload kbbug kbfix kbqfe KB239573