ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   row counter tool for excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/179372-row-counter-tool-excel-2003-a.html)

Ferds

row counter tool for excel 2003
 
Is there a row counter for highlited rows Excel 2003..?

Rick Rothstein \(MVP - VB\)[_193_]

row counter tool for excel 2003
 
Do you mean within a VBA macro or function? If yes, then this will tell you
how many rows are in the selection...

Selection.Rows.Count

Rick


"Ferds" wrote in message
...
Is there a row counter for highlited rows Excel 2003..?



Rick Rothstein \(MVP - VB\)[_194_]

row counter tool for excel 2003
 
While you are making the actual selection (before you release the left mouse
button), the number of rows and columns is displayed in the Name Box (the
one to the left of the formula bar)... is that what you are looking for?

Rick


"Ferds" wrote in message
...
Is there a row counter for highlited rows Excel 2003..?




All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com