Count Highlighted Rows

[Anonymous]

How do I count the number of highlighted rows?

Thanks!

 

[Marcelo]

Hi,

take a look at
http://www.cpearson.com/excel/SortByColor.htm

or if you just want to know how many numbers are in selected rows, right
click below the sheets guide and chose count

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Anonymous" escreveu:

 

[Kevin B]

If you want the count displayed in a cell as result, you can use the
following custom function:

Function CountEm() As Long

Dim lngRows As Long

lngRows = Selection.Rows.Count

CountEm = lngRows

End Function

 

[Anonymous]

I created the function. However, when I put =countem() in a cell I get the
following error:

#NAME?

 

[Kevin B]

If you put the function in a worksheet module you will get the #Name error.

Press Alt+F11 to open the VBE and insert a new module by clicking INSERT in
the menu and selecting MODULE. Double click on the Sheet# icon under the
Microsoft Excel Objects folder in the VBA Project Explorer window, cut the
formula and paste it into the new module.

Add the following line under the Dim statement:

Application.Volatile

This will force the formula to recalc whenever the worksheet recalcs or you
press F9