How to Find numbers of Rows for specific column in Excel File.I have used
Usedrange.Rows.count but it will give you maximum number of rows but I want
number of rows for specific column in Excel File
Set xl =CreateObject("Excel.Application")
Set wb = xl.Workbooks.Open ("Test Plan.xlsx")
Set ws = wb.worksheets(1)
'rc= ws.UsedRange.Rows.count
'
'msgbox rc
--
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
---
You received this message because you are subscribed to the Google Groups "QTP
- HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
