Table Cells

  • Thread starter Thread starter Ross from Orlando
  • Start date Start date
R

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
 
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 -
Click to expand...

Thanks, Susan, but it does not work in Word 2007. I think that
sometimes creating an Excel spreadsheet and pasting into Word is
easier.
 
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 -
Click to expand...

Thanks, Susan, but it does not work in Word 2007. I think that
sometimes creating an Excel spreadsheet and pasting into Word is
easier.
 
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
 
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,
Click to expand...
Ross- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

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

Ross
 
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

Ross from Orlando said:
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,
Click to expand...
Ross- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

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

Ross
Click to expand...
 
Back
Top