[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Getting Record count for Excel

What is the Function name for getting a recount in an excel spread sheet.  I am using VB5 or you can give it to me as a VBA.  I am querying an excel spread sheet, I need to know how many records there are so I can process the data in a For..Loop..

Thanks.
0
strongd
Asked:
strongd
1 Solution
 
EugenyCommented:
sheets("YoeruSheetName").UsedRange.Rows.Count
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now