Count from A5 down to last used row - Not up

's Computer Specifications

Hi all,

Is it possible to count the used rows from A5 down to the last used row ?

As i have data further down in column A, so cannot count up.
--
Les

's Computer Specifications

Use xlDown instead of xlUp...

dim rng as range

set rng = range(range("a5"), range("A5").end(xlDown))
msgbox rng.count
--
HTH...

Jim Thomlinson

"Les" wrote:

> Hi all,
>
> Is it possible to count the used rows from A5 down to the last used row ?
>
> As i have data further down in column A, so cannot count up.
> --
> Les

's Computer Specifications

Thanks Jim, much appreciated

--
Les

"Jim Thomlinson" wrote:

> Use xlDown instead of xlUp...
>
> dim rng as range
>
> set rng = range(range("a5"), range("A5").end(xlDown))
> msgbox rng.count
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Les" wrote:
>
> > Hi all,
> >
> > Is it possible to count the used rows from A5 down to the last used row ?
> >
> > As i have data further down in column A, so cannot count up.
> > --
> > Les

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count duplicats, display incremental count, restart count at changein value	JenIT	Microsoft Excel Programming	2	24th Aug 2010 09:10 PM
Count unique field1 combined with count field2, both grouped andungrouped	john.mctigue@health.wa.gov.au	Microsoft Access Queries	3	19th Dec 2008 03:52 AM
Count Employee Work Time - Don't Double-count Overlapping Apts.	=?Utf-8?B?Sg==?=	Microsoft Excel Worksheet Functions	0	27th Apr 2007 05:52 AM
how to get count(col1), count(col2), count(sol3) with only one query	Mario Krsnic	Microsoft Access Queries	2	27th Oct 2006 06:52 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row	Sam via OfficeKB.com	Microsoft Excel Worksheet Functions	9	31st Jul 2005 03:37 AM