Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page simple way to count rows in a table?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2015, 06:09 PM
bkcell bkcell is offline simple way to count rows in a table? Windows 7 64bit simple way to count rows in a table? Office 2007
Advanced Beginner
simple way to count rows in a table? 		 
Join Date: Jul 2011
Posts: 35
bkcell is on a distinguished road
Default simple way to count rows in a table?

is there a simple way to get a row count from a table?
Reply With Quote
  #2  
Old 03-09-2015, 07:13 PM
Guessed's Avatar
Guessed Guessed is offline simple way to count rows in a table? Windows 7 32bit simple way to count rows in a table? Office 2010 32bit
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
By eye or by macro?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 03-09-2015, 08:12 PM
bkcell bkcell is offline simple way to count rows in a table? Windows 7 64bit simple way to count rows in a table? Office 2007
Advanced Beginner
simple way to count rows in a table? 		 
Join Date: Jul 2011
Posts: 35
bkcell is on a distinguished road
Default
already tried it by eye...gave up around 11,000
Reply With Quote
  #4  
Old 03-09-2015, 08:22 PM
Guessed's Avatar
Guessed Guessed is offline simple way to count rows in a table? Windows 7 32bit simple way to count rows in a table? Office 2010 32bit
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
OK then, lets assume you want a macro before your eye falls out
Code:
Sub CountRows()
  msgbox Selection.Tables(1).Rows.Count
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 03-09-2015, 09:06 PM
bkcell bkcell is offline simple way to count rows in a table? Windows 7 64bit simple way to count rows in a table? Office 2007
Advanced Beginner
simple way to count rows in a table? 		 
Join Date: Jul 2011
Posts: 35
bkcell is on a distinguished road
Default
thanks very much
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to count the columns between two points on a table? bobsone1 Excel 2 08-14-2014 01:42 AM
simple way to count rows in a table? Is it possible to copy non-contiguous rows of a Table and paste them as a separate Table in Word? Joey Cheung Word Tables 1 08-12-2014 05:15 PM
simple way to count rows in a table? Adding Rows to a Table SuzeG Word VBA 8 01-02-2014 08:05 AM
simple way to count rows in a table? Grouping table rows to prevent individual rows from breaking across pages dennist77 Word 1 10-29-2013 11:39 PM
simple way to count rows in a table? Count rows and add blank rows accordingly Hoochtheseal Word VBA 1 01-29-2013 09:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft