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
|