If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting rows in a word table 2003
I have a very large Word table - over 1000 rows. It
contains name and address information. I want to count how many records I have i.e. how many rows in the table. The count(above) function returns 0. The line indicator in the status bar only appears to stop at 999. Some rows have more than one paragraph in them - but I want that still to count as 1 I am in the process of turning this into an Access table but I need to know I am transferring the correct number of records. Any help would be greatly appreciated. Mary Ann |
#2
|
|||
|
|||
Counting rows in a word table 2003
Hi Mary Ann
The quickest way I know is to put the cursor in the last row of the table, and open the Table Properties dialog. Click on the Row tab. The row number will be shown just below the Size heading. With a little more setup, you can have one-button access to the row count, and the cursor can be anywhere within the table. Use the procedure at http://www.gmayor.com/installing_macro.htm to install this macro and assign a toolbar button to it: Sub RowCount() If Not Selection.Information(wdWithInTable) Then MsgBox "Put the cursor in the table first." Exit Sub End If MsgBox Selection.Tables(1).Rows.Count & " rows" End Sub -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Mary Ann wrote: I have a very large Word table - over 1000 rows. It contains name and address information. I want to count how many records I have i.e. how many rows in the table. The count(above) function returns 0. The line indicator in the status bar only appears to stop at 999. Some rows have more than one paragraph in them - but I want that still to count as 1 I am in the process of turning this into an Access table but I need to know I am transferring the correct number of records. Any help would be greatly appreciated. Mary Ann |
#3
|
|||
|
|||
Counting rows in a word table 2003
Get the TableCellHelper macro from
http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm. When you run it, it returns the address of the current cell and the total number of rows and columns in the table. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Mary Ann" wrote in message ... I have a very large Word table - over 1000 rows. It contains name and address information. I want to count how many records I have i.e. how many rows in the table. The count(above) function returns 0. The line indicator in the status bar only appears to stop at 999. Some rows have more than one paragraph in them - but I want that still to count as 1 I am in the process of turning this into an Access table but I need to know I am transferring the correct number of records. Any help would be greatly appreciated. Mary Ann |
#4
|
|||
|
|||
Counting rows in a word table 2003
Thank you Suzanne and Jay - all tips fabulously useful.
Mary Ann -----Original Message----- I have a very large Word table - over 1000 rows. It contains name and address information. I want to count how many records I have i.e. how many rows in the table. The count(above) function returns 0. The line indicator in the status bar only appears to stop at 999. Some rows have more than one paragraph in them - but I want that still to count as 1 I am in the process of turning this into an Access table but I need to know I am transferring the correct number of records. Any help would be greatly appreciated. Mary Ann . |
Thread Tools | |
Display Modes | |
|
|