In a xl sheet I just need to count the number of rows

eg highlight and be advised there are 5 rows

hfhfdhfd
hfdhdf
gfgfg
hdfhfdh
djfdjfdj



Now I use the summation to add up the contents of say simple numbers but I
would just like to highlight a range of cells or rows and just have a
simple way of knowing how many rows there are.

Which ever is the simplest method.

Thanks in advance

Sammy

If I understand your question, you can use =COUNTA(A1:A1000) adjust range to
your needs
Regards
Cimjet
"sammy" wrote in message
...
In a xl sheet I just need to count the number of rows

eg highlight and be advised there are 5 rows

hfhfdhfd
hfdhdf
gfgfg
hdfhfdh
djfdjfdj



Now I use the summation to add up the contents of say simple numbers but I
would just like to highlight a range of cells or rows and just have a
simple way of knowing how many rows there are.

Which ever is the simplest method.

Thanks in advance

Sammy

run this macro:

Sub rowcount()
MsgBox (Selection.Rows.Count)
End Sub

--
Gary''s Student - gsnu2007j


"sammy" wrote:

In a xl sheet I just need to count the number of rows

eg highlight and be advised there are 5 rows

hfhfdhfd
hfdhdf
gfgfg
hdfhfdh
djfdjfdj



Now I use the summation to add up the contents of say simple numbers but I
would just like to highlight a range of cells or rows and just have a
simple way of knowing how many rows there are.

Which ever is the simplest method.

Thanks in advance

Sammy

Even Easier: Select one column of data or the range of cells you want to count
Click the arrow next to the AutoSum on the Standard toolbar, then click
Count and press ENTER.

Once you have selected the cells, you may also see "SUM = NNN" on the Status
Bar at the bottom right. If you Right Click on SUM a selection menu will
appear, Left Click on Count and it will tell you how many rows you have
selected.


"sammy" wrote:

In a xl sheet I just need to count the number of rows

eg highlight and be advised there are 5 rows

hfhfdhfd
hfdhdf
gfgfg
hdfhfdh
djfdjfdj



Now I use the summation to add up the contents of say simple numbers but I
would just like to highlight a range of cells or rows and just have a
simple way of knowing how many rows there are.

Which ever is the simplest method.

Thanks in advance

Sammy

Yes thats exactly what I wanted thanks

Is there any short handway of doing without having to type in the cell eg
=COUNTA(A1:A1000)

Thanks again
Sammy

"Cimjet" wrote in message
...
If I understand your question, you can use =COUNTA(A1:A1000) adjust range
to your needs
Regards
Cimjet
"sammy" wrote in message
...
In a xl sheet I just need to count the number of rows

eg highlight and be advised there are 5 rows

hfhfdhfd
hfdhdf
gfgfg
hdfhfdh
djfdjfdj



Now I use the summation to add up the contents of say simple numbers but
I would just like to highlight a range of cells or rows and just have a
simple way of knowing how many rows there are.

Which ever is the simplest method.

Thanks in advance

Sammy

Why is it exactly what you wanted?

Do you want to count how many rows have data in a selection which may include
blank cells?

The Count on the Status bar will do just that.


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 21:39:27 GMT, "sammy" wrote:

Yes thats exactly what I wanted thanks

Is there any short handway of doing without having to type in the cell eg
=COUNTA(A1:A1000)

Thanks again
Sammy

"Cimjet" wrote in message
...
If I understand your question, you can use =COUNTA(A1:A1000) adjust range
to your needs
Regards
Cimjet
"sammy" wrote in message
...
In a xl sheet I just need to count the number of rows

eg highlight and be advised there are 5 rows

hfhfdhfd
hfdhdf
gfgfg
hdfhfdh
djfdjfdj



Now I use the summation to add up the contents of say simple numbers but
I would just like to highlight a range of cells or rows and just have a
simple way of knowing how many rows there are.

Which ever is the simplest method.

Thanks in advance

Sammy