View Single Post
  #3   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Help me with a formula in Table

Hi BigOz,

You can find the cell address for a given cell by running the following macro. The cell address is displayed on the status bar.
Sub CellAddress()
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
[MVP - Microsoft Word]


"BigOz" wrote in message ...
I want a count.

in column F2:F27, how many "F" (or "M") are there in the column
--
Sua Sponte