| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of rows not empty
A beginner question:
how, in VBA, do I get the number of rows that are not MT in a sheet ? In other words, how do I make VBA count the number of records in a sheet, assuming that the first MT row is the end of the file Thank you Jacquelin Hardy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number of rows not empty
NumRows = Application.Counta(Columns(1)))
"gps 4 pilots" wrote in message ... A beginner question: how, in VBA, do I get the number of rows that are not MT in a sheet ? In other words, how do I make VBA count the number of records in a sheet, assuming that the first MT row is the end of the file Thank you Jacquelin Hardy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number of rows not empty
set rng = cells(rows.count,1).End(xlup)
msgbox "number of non empty rows is " & rng.row Number of records would be one less than that if the first row is a header row. -- Regards, Tom Ogilvy "gps 4 pilots" wrote in message ... A beginner question: how, in VBA, do I get the number of rows that are not MT in a sheet ? In other words, how do I make VBA count the number of records in a sheet, assuming that the first MT row is the end of the file Thank you Jacquelin Hardy |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number of rows not empty
Thank's Tom
Thank's Bob JH "Tom Ogilvy" wrote in message ... set rng = cells(rows.count,1).End(xlup) msgbox "number of non empty rows is " & rng.row Number of records would be one less than that if the first row is a header row. -- Regards, Tom Ogilvy "gps 4 pilots" wrote in message ... A beginner question: how, in VBA, do I get the number of rows that are not MT in a sheet ? In other words, how do I make VBA count the number of records in a sheet, assuming that the first MT row is the end of the file Thank you Jacquelin Hardy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do U number a list of names, but there are empty rows in betw | Excel Discussion (Misc queries) | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How do I sort with empty rows between none empty rows? | Excel Worksheet Functions | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
| Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
Hybrid Mode
