Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting cells in a range
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 |
#2
|
|||
|
|||
Charles,
From VBE, in the immediate window, you could type selection.count to find the total number of cells selected in a range http://HelpExcel.com "Charles" wrote: 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 |
#3
|
|||
|
|||
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 "galimi" wrote: Charles, From VBE, in the immediate window, you could type selection.count to find the total number of cells selected in a range http://HelpExcel.com "Charles" wrote: 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 |
#4
|
|||
|
|||
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 "Charles" wrote: 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 "galimi" wrote: Charles, From VBE, in the immediate window, you could type selection.count to find the total number of cells selected in a range http://HelpExcel.com "Charles" wrote: 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 |
#5
|
|||
|
|||
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. "Charles" wrote: 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 "galimi" wrote: Charles, From VBE, in the immediate window, you could type selection.count to find the total number of cells selected in a range http://HelpExcel.com "Charles" wrote: 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 |
#6
|
|||
|
|||
And just in case that statusbar isn't visible:
Tools|options|view tab check statusbar IanRoy wrote: 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. "Charles" wrote: 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 "galimi" wrote: Charles, From VBE, in the immediate window, you could type selection.count to find the total number of cells selected in a range http://HelpExcel.com "Charles" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
counting text cells | Excel Worksheet Functions | |||
Formula help for using a range of cells! | Excel Worksheet Functions | |||
How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions |