Table Cells

[Ross from Orlando]

In Word 2007, is there a quick way to determine what table cell you
the insertion point is in? I have a vague recolleciton of a feature to
do this in earlier versions of Word. Thanks,

Ross

 

[Suzanne S. Barnhill]

See if either of the macros at
http://word.mvps.org/FAQs/AppErrors/SumAboveIncorrect.htm and
http://gregmaxey.mvps.org/Table_Cell_Data.htm will work in Word 2007.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Ross from Orlando]

See if either of the macros athttp://word.mvps.org/FAQs/AppErrors/SumAboveIncorrect.htmandhttp://gregmaxey.mvps.org/Table_Cell_Data.htmwill work in Word 2007.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USAhttp://word.mvps.org






- Show quoted text -

Thanks, Susan, but it does not work in Word 2007. I think that
sometimes creating an Excel spreadsheet and pasting into Word is
easier.

 

[Suzanne S. Barnhill]

That's interesting because I have the macro from
http://word.mvps.org/FAQs/AppErrors/SumAboveIncorrect.htm installed in Word
2007, and it works as advertised.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

See if either of the macros
athttp://word.mvps.org/FAQs/AppErrors/SumAboveIncorrect.htmandhttp://gregmaxey.mvps.org/Table_Cell_Data.htmwill
work in Word 2007.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USAhttp://word.mvps.org

message




- Show quoted text -

Thanks, Susan, but it does not work in Word 2007. I think that
sometimes creating an Excel spreadsheet and pasting into Word is
easier.

 

[macropod]

Hi Ross,

The following macro works in Word 2007 too:

Sub CellAddress()
'This macro displays the address of a table cell on Word's status bar
If Selection.Information(wdWithInTable) = True Then
If Selection.Cells(1).ColumnIndex > 26 Then
StatusBar = "Cell Address: " & Chr(64 + Int(Selection.Cells(1).ColumnIndex / 26)) & _
Chr(64 + (Selection.Cells(1).ColumnIndex Mod 26)) & Selection.Cells(1).RowIndex
Else
StatusBar = "Cell Address: " & Chr(64 + Selection.Cells(1).ColumnIndex) & _
Selection.Cells(1).RowIndex
End If
End If
End Sub

 

[Ross from Orlando]

Hi Ross,

The following macro works in Word 2007 too:

Sub CellAddress()
'This macro displays the address of a table cell on Word's status bar
If Selection.Information(wdWithInTable) = True Then
  If Selection.Cells(1).ColumnIndex > 26 Then
    StatusBar = "Cell Address: " & Chr(64 + Int(Selection.Cells(1).ColumnIndex / 26)) & _
    Chr(64 + (Selection.Cells(1).ColumnIndex Mod 26)) & Selection.Cells(1).RowIndex
  Else
    StatusBar = "Cell Address: " & Chr(64 + Selection.Cells(1).ColumnIndex) & _
    Selection.Cells(1).RowIndex
  End If
End If
End Sub

--
Cheers
macropod
[Microsoft MVP - Word]

In Word 2007, is there a quick way to determine what table cell you
the insertion point is in? I have a vague recolleciton of a feature to
do this in earlier versions of Word. Thanks,

Ross- Hide quoted text -

- Show quoted text -

Well, I figured this out, and the long and the short of it is that
both macros work. Thanks,

Ross

 

[Doug Robbins - Word MVP]

Beware however of the potentially misleading result if the table contains
merged cells.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

Hi Ross,

The following macro works in Word 2007 too:

Sub CellAddress()
'This macro displays the address of a table cell on Word's status bar
If Selection.Information(wdWithInTable) = True Then
If Selection.Cells(1).ColumnIndex > 26 Then
StatusBar = "Cell Address: " & Chr(64 +
Int(Selection.Cells(1).ColumnIndex / 26)) & _
Chr(64 + (Selection.Cells(1).ColumnIndex Mod 26)) &
Selection.Cells(1).RowIndex
Else
StatusBar = "Cell Address: " & Chr(64 +
Selection.Cells(1).ColumnIndex) & _
Selection.Cells(1).RowIndex
End If
End If
End Sub

--
Cheers
macropod
[Microsoft MVP - Word]

message

In Word 2007, is there a quick way to determine what table cell you
the insertion point is in? I have a vague recolleciton of a feature to
do this in earlier versions of Word. Thanks,

Ross- Hide quoted text -

- Show quoted text -

Well, I figured this out, and the long and the short of it is that
both macros work. Thanks,

Ross