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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how you can count the number of cells that are highlighted
 
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
(e-mail address removed)
chipsters said:
Does anyone know how you can count the number of cells that are
Click to expand...
highlighted
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting highlighted cells 2
Count Highlited Cells 3
How do I add cells by highlighting them? 2
Need to highlight cells in special order 0
Count if cell is highlighted 2
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
i would like to sum only highlighted text in a row 2

Back
Top