counting cells in a range

C

Charles

hi, I saw in other persons when has a range marked with the mouse, appear the
cells quantity that has the range,
how is the way to obtain it in my excel, maybe an option in option menu, but
i couldnt found....
any help me ?
thanks
 
C

Charles

thank galimi, but I refered without use VBE,
Is there not an option from excel menu ? because the person that I saw I
know dont use VBE
 
G

galimi

You can add the following code to the workbook_selectionchange event

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
Application.StatusBar = Target.Cells.Count
End Sub

This will put the cell count on the Status Bar. To enhance this further,
you could create an addin that monitors ALL Workbook Selection Changes using
the WithEvents keyword to make it work for ALL workbooks.

http://HelpExcel.com
 
I

IanRoy

Hi, Charles;
Right click the Status Bar at the bottom of your Excel window. Choose
"Count." If you don't see the Status Bar, go to "View" on the Menu Bar, and
check "Status Bar."
Regards,
Ian.
 
D

Dave Peterson

And just in case that statusbar isn't visible:

Tools|options|view tab
check statusbar
 
Top