Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate Number of rows in Excel ?
Hi ,
I have an excel sheet. i want to calculate the number of rows in the excel sheet using Vb6. This is the code that i have: Dim S As String Dim rlmt As Integer Open CommonDialog1.FileName For Input As #1 rlmt = 0 ' To get the number of rows While Not EOF(1) Line Input #1, S rlmt = rlmt + 1 Wend Close #1 MsgBox (rlmt) this code seems to give me more no of rows than what is actually there. Example, i had 7327 rows but my output using this code was 7330. Any help???? Thanks, anu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate number of rows and apply formula | Excel Discussion (Misc queries) | |||
Can you calculate the number of years between two dates in Excel 0 | Excel Worksheet Functions | |||
How do I calculate the root of a number using Excel? | Excel Worksheet Functions | |||
How do I calculate number of Mondays in a given month in Excel? | Excel Worksheet Functions | |||
How to calculate number of month from 2008 in Excel? | Excel Programming |