What would the formula be for counting highlighted cells in Excel.

[chipsters]

Does anyone know how you can count the number of cells that are highlighted

 

[Chip Pearson]

Try something like the following:

Dim CellCount As Long
CellCount = Selection.Cells.Count


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message
news:[email protected]...

 

[Don Guillett]

If by hightlighted means selected

Sub countselectedcells()
ms = 0
For Each c In Selection
ms = ms + 1
Next
MsgBox ms
End Sub

--
Don Guillett
SalesAid Software
[email protected]

Does anyone know how you can count the number of cells that are

highlighted

 

[mroby]

On the lower right of the screen below the scrollbar, there are some grey
boxes. Rightclick on the second box. You can then click on 'count' it will
then display a count for whatever you highlight.

 

[Gord Dibben]

By "highlighted" do you mean those with a background color?

If not, see the other posts.

If so, see Chip Pearson's working with colors page.

http://www.cpearson.com/excel/colors.htm

Gord Dibben Excel MVP

 

[Myrna Larson]

Won't

Selection.Count

do as well, and lots faster?

 

[Don Guillett]

Sure would. Sometimes I just don't think......