New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
to count the number of used rows in a particular column

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
to count the number of used rows in a particular column
supputuri Offline
Moderator
*****
Posts: 516
Threads: 17
Joined: Jul 2009
Reputation: 3
#2
Not Solved 06-12-2013, 11:04 AM
Used the below LOC long back... checkout and let me know if you need any help

Code:
intLastRow = Cells(Cells.Rows.Count,"A").End(xlUp).Row
OR
intEndRow = Cells(ActiveSheet.UsedRange.Rows.Count+1,ActiveCell.Column).End(xlUp).Row
Thanks,
SUpputuri
Find
Reply


Messages In This Thread
RE: to count the number of used rows in a particular column - by supputuri - 06-12-2013, 11:04 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  does WebTable Object provides a method to get column number umer830 4 13,046 07-06-2018, 09:32 AM
Last Post: vijaychourasiya0109@gmail.com
  How to Delete Rows with duplicate values in 1 columns in excel thru QTP. arpan 0 2,852 02-09-2015, 08:47 PM
Last Post: arpan
  How to get center data value in a odd number of rows and columns web table ... sai rajesh 0 2,836 11-13-2013, 10:24 PM
Last Post: sai rajesh
  Problem with Multiple rows retrieval from mySQL and save it some variable Dejavu 1 2,182 03-15-2013, 02:52 PM
Last Post: basanth27
  Wrong count for UsedRange rows and columns in datatable. qtpexpert 2 6,436 06-20-2012, 04:35 PM
Last Post: qtpexpert

Forum Jump:


Users browsing this thread: 1 Guest(s)