A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Counting rows in a word table 2003



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2004, 06:10 PM
Mary Ann
external usenet poster
 
Posts: n/a
Default 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  
Old May 19th, 2004, 08:25 PM
Jay Freedman
external usenet poster
 
Posts: n/a
Default 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  
Old May 20th, 2004, 12:11 AM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default 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  
Old May 20th, 2004, 08:51 AM
Mary Ann
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:06 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.