to count the number of used rows in a particular column

Thread Rating:

Thread Modes

to count the number of used rows in a particular column

sujaravi123 Offline

Junior Member

Posts: 20
Threads: 11
Joined: Oct 2011
Reputation: 0

06-12-2013, 12:53 PM

Itried both as below.But shows run time error Sad

Code:
intLastRow = Cells(ActiveSheet.Rows.Count,"A").End(xlUp).Row

Code:
intEndRow = Cells(ActiveSheet.UsedRange.Rows.Count+1,ActiveCell.Column).End(xlUp).Row

--------------------------------------------------------------------------------

Find

« Next Oldest | Next Newest »

Messages In This Thread

RE: to count the number of used rows in a particular column - by sujaravi123 - 06-12-2013, 12:53 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	does WebTable Object provides a method to get column number	umer830	4	13,947	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	3,159	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	3,164	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,488	03-15-2013, 02:52 PM Last Post: basanth27
	Wrong count for UsedRange rows and columns in datatable.	qtpexpert	2	6,921	06-20-2012, 04:35 PM Last Post: qtpexpert

Users browsing this thread: 3 Guest(s)