Thread: simple way to count rows in a table?
View Single Post
 
Old 03-09-2015, 08:22 PM
Guessed's Avatar
Guessed Guessed is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,981
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