Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Retiving the number of rows using VBA
- Thread starter dizzy880
- Start date
Dizzy,
There's really two ways to go about this. If you simply need to return the number of rows in a report on a report tab, insert a cell and add a variable using the function:
=NumberOfRows("DataProviderName"
To access via VBA, the appropriate syntax is to define it:
NbRowsFetched As Long
...and use this syntax:
DataProviderName.NbRowsFetched
All of this information is available in the SDK.
Hope it helps.
V
There's really two ways to go about this. If you simply need to return the number of rows in a report on a report tab, insert a cell and add a variable using the function:
=NumberOfRows("DataProviderName"
To access via VBA, the appropriate syntax is to define it:
NbRowsFetched As Long
...and use this syntax:
DataProviderName.NbRowsFetched
All of this information is available in the SDK.
Hope it helps.
V
- Status
Similar threads
- Locked
- Question
- Locked
- Question