![]() |
|
#2
|
||||
|
||||
|
It is easy enough with a macro. The following assumes the result will go in the last cell in the column containing the cursor and that there are no merged/split cells in the table.
Code:
Sub CountNums()
Dim oTable As Table
Dim lngCount As Long: lngCount = 0
Dim oCell As Cell
Dim oRng As Range
Dim i As Integer
Dim iCol As Integer
Dim iRow As Integer
Set oTable = Selection.Tables(1)
iRow = oTable.Rows.Count
If Selection.InRange(oTable.Range) = True Then
iCol = Selection.Cells(1).ColumnIndex
For i = 1 To iRow - 1
lngCount = lngCount + Split(oTable.Columns(iCol).Cells(i).Range.Text, Chr(32))(0)
Next i
Set oRng = oTable.Columns(iCol).Cells(iRow).Range
oRng.End = oRng.End - 1
oRng.Text = lngCount
End If
lbl_Exit:
Set oCell = Nothing
Set oRng = Nothing
Exit Sub
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Sorting numbers within cell
|
michaelst | Excel | 9 | 04-22-2017 10:51 PM |
| Difference between 2 numbers in same cell | Neila1982 | Excel | 1 | 02-12-2017 01:40 AM |
Add Numbers from One or Another Cell
|
Kilch | Excel | 3 | 01-31-2017 12:55 PM |
| Search a cell that contains words and numbers and convert the numbers to metric | Carchee | Excel Programming | 36 | 10-08-2014 03:16 PM |
adding numbers in same cell
|
jetdude68 | Word Tables | 1 | 07-20-2010 12:30 AM |